 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Added page won't incorporate into original spreadsheet Excel 2003
I have a 3 page spreadsheet in Excel 2003 that I have used for years. The footer has automatic page numbering in it. I hit file>print and it prints the 3 pages number 1 through 3. I need more space so I inserted a Page Break near the end of page 3 and set up the stuff for what I thought would be page 4. It looks good on the monitor but when I go to print, it only prints pages 1-3 and not 4. If I highlight the cells that are intended to print as page 4, it will print them on one sheet but it numbers it as page 1 of 1. I can get the thing printed but it is a 2 step process. Somehow the page I added is not being considered as the 4th page of the original spreadsheet. This is a little perplexing to me. I'm not really experienced with Excel and I suspect it has something to do with workbooks/sheets, or something. Any help would be greatly appreciated. Thanks. Chet Do you have your print paramets set to print All pages or just pages 1 through 3? Tyro >I have a 3 page spreadsheet in Excel 2003 that I have used for years. The >footer has automatic page numbering in it. I hit file>print and it prints [quoted text clipped - 15 lines] > Thanks. > Chet I have it set to "All Pages" and then for "What to Print" I've tried them all, i.e. selection, active sheets, and entire workbook. I've tried all the options and combinations I can on the print menu. Chet > Do you have your print paramets set to print All pages or just pages 1 > through 3? [quoted text clipped - 20 lines] >> Thanks. >> Chet Think I found the answer. Highlight everything you want to print (i.e. all 4 pages in this case) then click of FILE>PRINT AREA> SET PRINT AREA and it will then do the pagination and print all four pages and treat the thing as one document. I would think there would be an easier way. Chet >I have a 3 page spreadsheet in Excel 2003 that I have used for years. The >footer has automatic page numbering in it. I hit file>print and it prints [quoted text clipped - 15 lines] > Thanks. > Chet Would have been better if you had stuck with the same thread so people would not still be answering there. Gord Dibben MS Excel MVP >Think I found the answer. Highlight everything you want to print (i.e. all >4 pages in this case) then click of FILE>PRINT AREA> SET PRINT AREA and it [quoted text clipped - 24 lines] >> Thanks. >> Chet Clear your original print area then establish a new print area. File>Print Area>Clear Print Area Select the area to print then File>Set Print Area Gord Dibben MS Excel MVP >I have a 3 page spreadsheet in Excel 2003 that I have used for years. The >footer has automatic page numbering in it. I hit file>print and it prints [quoted text clipped - 14 lines] >Thanks. >Chet Gord, You said: "Would have been better if you had stuck with the same thread so people would not still be answering there. Gord Dibben MS Excel MVP" I only got one reply and that was from "Tyro" and it was an attempt to help but it didn't work. I had not posted any other threads nor on any other lists. I figured it out on my own, by luck, and it was the way you recommend. I didn't see any other people trying to answer it, perhaps because I sent a note in, altering the subject line so that people could see that I thought I had solved it and they didn't need to read the note unless they were curious. I thought this was all in the original thread and would be obvious. So far it only involves 3 people, you, me and Tyro. At any rate, thank you for your reply. I know that if a question is spotted and replied to by an MS MVP, the correct answer will be forthcoming. 'Nuff said. I don't want to clutter up the list any more. I'm just not sure where I violated "protocol" with the posting and I may be guilty again, unintentionally. Thanks. Chet > Clear your original print area then establish a new print area. > [quoted text clipped - 24 lines] >>Thanks. >>Chet The post I replied to with "Would have been better if you had stuck with the same thread" was not this thread. You started a new one when you altered the Subject line to " Solved it Re: Added page won't incorporate into original spreadsheet Excel 2003" Gord >Gord, >You said: "Would have been better if you had stuck with the same thread so [quoted text clipped - 52 lines] >>>Thanks. >>>Chet |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.