Conditional page break
Hello everybody,is there a way in Excel to insert page break(s) depending from datas?Better: I have an invoice list:invoice # amount article ecc.1001 4000 C01 ...1001 5000 C021001 4500 C031001 3000 C041005 6700 C011005 4000 C04..and I want a page break _after_ the invoice number changes.Is it possible to do that?ThanksN! Xau N! Xau, try this if your invoice numbers are ..
Page breaks around every cell (Excel)
Every now and then I get page breaks around every cell. What causesthat and how do I get rid of them?..
Word documents only open as half pages
I have a students whose Word documents only open as half pages instead of full pages. This is not a magnification issue, but rather only the top half of the screen appears. Any suggestions? -- SusanY Document windows are resizeable. Drag to show the rest of the document window. Word should remember the window size and position (stored in the registry) the next time it's opened. If it reverts to the half window, then there's probably a corrupted Word Data registry entry. Because you didn't specify the version of Word, I can't tell you where it is in the regist..
rotation
Is there a way in excel to rotate the contents of the cell to 180 degrees?Thanks Yep ........ Format>CELLS>alignment select the required orientation'mireillea' <mireillea@newhorizons.com.lb> wrote in messagenews:e5u7s8NZEHA.2972@TK2MSFTNGP12.phx.gbl..> Is there a way in excel to rotate the contents of the cell to 180 degrees?> Thanks>> Your system clock appears to be off since I show receipt at 7/9 @ 4:31 am-- Don GuillettSalesAid Softwaredonaldb@281.com'mireillea' <mireillea@newhorizons.com.lb> wrote in messagenew..
Button hidden in Continuous form depending on specific record value
Hi everyone,I've created a continuous form and I'm trying to display (or hide) a control(text field or button) depending on the result of a combo box entry in eachindividual record. Up to this point I've been able to create the code thatwill display or hide the control but it does so for each record on the form.Would you know a way to do it on a record by record basis??Thanks,Bruno. While it may look as though you've got, say, 20 buttons on the form when there are 20 rows of data, in actual fact there's only a single button, repeated 20 times. That means that ..
How can I cross reference a SmartArt Graphic to a page/text?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am trying to allow users to click on the SmartArt Graphic on my first page and automatically go to the respective page within the document. I click next to the wording on the graphic and go to Insert, but it will not allow me to insert the cross reference. You can do it the other way around - from the text to the graphic, but not from the graphic to the text. Anyone know a way around this or another way to do it? Objects cannot be used as active hyperlinks in a Word document. You can do what you describ..
Outlook Today as 'Default Home Page' for Email/Tasks/Calendar
HiI have set Outlook Today as the page to open when I fire up Outlook (2007). I like it.BUT can I get it to display the Calendar, not just a list of appointments that I have IN my calendar, but the week ahead calendar itself?Tks n RgdsRodPerth no, you only get a list of future appointments.-- Diane Poremsky [MVP - Outlook]Outlook Tips: http://www.outlook-tips.net/Outlook & Exchange Solutions Center: http://www.slipstick.comOutlook Tips by email:dailytips-subscribe-request@lists.outlooktips.netEMO - a weekly newsletter about Outlook and Exchange:EMO-NEWSLETTER-SUBSCR..
Page Setup shows 2 cm top margin, yet the page hs no top margin a.
When I open MS word (2003), my page setup appears to have no top margin, however on opening the Page Setup window it indicates 2cm. Changing this value seems to have no effect either. This problem seems to have come from nowhere quite recently, with MS Word working perfectly normally for the past few years.. Any ideas?! See http://sbarnhill.mvps.org/WordFAQs/WhiteSpace.htm. Hope this helps DeanH 'Spugford' wrote: > When I open MS word (2003), my page setup appears to have no top margin, > however on opening the Page Setup window it indicates 2cm. Ch..
Can I add a scissors line down a page (in between two pages)?
Hi,Is it possible to add a scissors line down a page?Thanks You mean like cutting out a coupon? BorderArt, draw a box, lines, more lines, borderart. You can draw a line and make it dashed..-- Mary Sauer MSFT MVPhttp://office.microsoft.com/http://msauer.mvps.org/news://msnews.microsoft.com'9thbit' <9thbit@discussions.microsoft.com> wrote in message news:B7FF49C3-B9AF-4A9F-AFFA-15BED6E9672B@microsoft.com..> Hi,> Is it possible to add a scissors line down a page?>> Thanks ..
Error On Page Message
How can I download a template if I get Error On Page Message Post the URL for the Template so's we(I) can try to download.May come up with something for you.Gord Dibben Excel MVPOn Sun, 20 Feb 2005 04:31:01 -0800, GeeJay <GeeJay@discussions.microsoft.com>wrote:>How can I download a template if I get Error On Page Message the URL is http://office.microsoft.com/en-us/templates/TC061011771033.aspxI cannot click download without getting Error on Page Message - thanks for the help'Gord Dibben' wrote:> Post the URL for the Template so's we(I) can try..
Change Button Color.
I have a push button, can I change the button color when it's been pushed?Thanks. You will need to owner draw it in MFC. There are several examples of doingthis at codeguru and codeproject. Take a look at those.--Ajay Kalra [MVP - VC++]ajaykalra@yahoo.com'Frank E Rogers' <syang@pelco.com> wrote in messagenews:eG$OPRMLEHA.2736@TK2MSFTNGP11.phx.gbl..> I have a push button, can I change the button color when it's been pushed?> Thanks.>>..
arrows on page
Help please, I have hit something on the keyboard by mistake and now everytinme I answer an email I have a pye symbol where I want to write and a dot between every word and an arrow pointing down and to the left at the end of every line. It is sending me bonkers. How do I stop it? Mandy wrote: > Help please, > > I have hit something on the keyboard by mistake and now everytinme I answer > an email I have a pye symbol where I want to write and a dot between every > word and an arrow pointing down and to the left at the end of every line. It > is sendi..
How I do I rotate text in an excel cell? The rotate commands is g.
I am trying to flip some text in an excel worksheet either as a block or opne cell at a time. However the rotate command in the Draw toolbar is greyed out. Anyone help?Thanks Mick Go to Format -> Cells - then go to the allignment tab - you will see that there is a control set in the bottom right for doing thistt5fn benm If the text is in a cell, you can rotate it up to 90 degrees using Format/Cells/Alignment..In article <4984E244-3011-4A69-8648-86F6A8BA85F0@microsoft.com>, 'MickG' <MickG@discussions.microsoft.com> wrote:> I am trying to flip some t..
is there a special way to centre pictures/text on the page
is there a special way to centre pictures/text on your page, Like centre horizontally or vertically, any options like that? cause i cant find them Mattias wrote:> is there a special way to centre pictures/text on your page,> Like centre horizontally or vertically, any options like that? cause> i cant find themWhich version of MS Publisher are you using?Try the options at: Arrange / Align or Distribute..-- John Inzer MS Picture It! -Digital Image MVP Digital ImageHighlights and FAQshttp://support.microsoft.com/ph/..
Shrinking pages
I have a flyer created on full page. How do i shrink the whole thing to print 4 per page or is that posible in publisher? While in a state of ecstasy after repairing his laptop, Ed sees amessage from Crickett <Crickett@discussions.microsoft.com>. On it iswritten:> I have a flyer created on full page. How do i shrink the whole thing> to print 4 per page or is that posible in publisher?This is not possible in Publisher - you can use a utility such as FinePrint (www.fineprint.com) to accomplish the same thing. Some printer drivers (HP, for example), offer this functionalit..
Text Rotation
Hi, In Word 2007, I can rotate the text left or right but I need the upside down text (180 degree) in edit able format i.e. able to update in Mail Merge process. Any one now how this task can be accomplish without an option of Word Art or using Paint software to flipping the text. Any help in this regard will be greatly appreciated I use a shape box. Go to Insert, Shapes, then select a square. Type your text. Now go to the Text Box Tools tab and click Format (if it is not already showing). From here you will be able to remove the Shape Outline/Fill and will be able to rot..
freeze a heading so it will show on every page as I scroll down
I have headings across the top of my page, as I continue to type in info, the headings 'disappear'. How can I make those 'freeze' so as I continue to add info in my spreadsheet I can still see the headings and so they will show up on each and every page when I print! http://www.officearticles.com/excel/repeat_rows_at_top_when_printing_in_microsoft_excel.htm************Anne Troywww.OfficeArticles.com'Karen' <Karen@discussions.microsoft.com> wrote in message news:092E7AC1-1C84-47ED-8AD2-8D1D409B5828@microsoft.com..>I have headings across the to..
Printer Friendly Email: Page Breaks
How do I insert a page break into the text of an email in Outlook Express 5? Any other tips on where to go to learn how to format email text using html? Thanks. This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Officefamily for Windows PCs. For Outlook Express (OE) support try posting in oneofthese newsgroups:microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.xmicrosoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.xhttp://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.windows.inetexplorer.ie5.outlookexpre..
News button is missing from customize toolbars
I tried to add the News button to allow the newsgroup reader function. It was there at first. I followed the instruction that said it was hidden, and I had to move it from the Customize Toolbar menu. I went under the Go section, and found News. I moved it to the Go section of my file menu, and it was there. I opened the newsgroup reader, and started to create a usenet account. I was missing some info for my account, so I canceled out and closed the newsgroup reader and Outlook. Now when I open Outlook, the News button that I put under the Go File menu is gone, and it isn't..
put calendar on two pages in publisher- calendar is 2 pages wide
When using publisher, I want to make a calendar that spreads across both pages. the templates only seem to allow me to put a calendar on one page. Is there a way to do this?thanks,Nancy J Are you creating a booklet? How are your pages setup? What size is your stock?-- Mary Sauer MSFT MVPhttp://office.microsoft.com/http://msauer.mvps.org/news://msnews.microsoft.com'nancyj' <nancyj@discussions.microsoft.com> wrote in message news:8F025D58-D86E-4CAA-BEAD-BB878FE6A40A@microsoft.com..> When using publisher, I want to make a calendar that spreads across both>..
Mail Merge Page Setup
I would like to know how to keep the same document settings from a mail merge template to the merged documents. I would like to set up features for printing etc in page set up. When I do this in my mail merge template the features do not move into the merged new document. Is this possible? How can I make this work? Thanks ..
rotate a sheet on its axis
255 columns is not enough for me. I'm wondering if there is a way to rotate my sheet 90 degrees so my columns are now rows and rows are now columns. Thank You On Jan 15, 12:30=A0pm, sramsey <sram..@discussions.microsoft.com> wrote: > 255 columns is not enough for me. =A0I'm wondering if there is a way to r= otate > my sheet 90 degrees so my columns are now rows and rows are now columns. > > Thank You Copy all your data then Paste Special (with the option transpose checked). It will do exactly what you need. Copy, then right-click, paste special, t..
some images not loading on home page or web pages
i have windows vista running on a toshiba laptop with 2 user accounts - one of the user accounts has no problem and all images are loaded when ever displayed - the other user account only gets some of the images on their home page and web pages but also boxes with red crosses inside where there should be images. Any suggestions as to how to make all these images load ok? Thanks There are many things that can cause this. However, based on only what you said, I would say it's possible one user has something running in the background hogging up any RAM or what little RAM y..
Importing pages from an existing Publisher document (2003)
I need to insert about 30 pages from an existing Publisher document into a new Publisher document. Is there an easy way to do this - short of copying and pasting everything?Thanks. Are the text boxes linked? Copying and pasting are tough when the text boxes are linked. If you open the Office Clipboard, you can collect 24 items.If you are game I have a method of combining Publisher documents on my web site. It is not for the faint of heart.http://msauer.mvps.org/combining_publisher_documents.htm-- Mary Sauer MSFT MVPhttp://office.microsoft.com/http://msauer.mvps.org/news://msnew..
ole notes present button on allother windows
ole notes present button is existing only on employee maintenance window.it should exist on all other windows so that end users can attach the files. ----------------This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the 'I Agree' button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click 'I Agree' in the message pane.http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dg..