Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
Set the Print Area to cover just your used cells.
If it spreads to more than one page after that, Page Setup/ Page will let you fit to one page. -- David Biddulph "dragonslay5" wrote in message ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? Thanks to everyone who replies! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
Thanks David but I want to change my document to only be one page.
Maybe I phrased my question badly. I want to permenantly resave my document as a one page only document. dragonslay5 "David Biddulph" wrote: Set the Print Area to cover just your used cells. If it spreads to more than one page after that, Page Setup/ Page will let you fit to one page. -- David Biddulph "dragonslay5" wrote in message ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? Thanks to everyone who replies! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
Unless you have formulas in those cells that
look empty, the problem is probably a "last used cell" problem. Use Ctrl+End to find the cell that Excel thinks is your last cell, which is the intersection of the rightmost used cell and the lowest down used cell. You can switch between formula view and values by using Ctrl+` (accent grave to left of number row) or by using Tools, Options, View, [x] formulas [view]. don't forget to uncheck formula view when done. What happens is that you insert rows, and you delete rows. When you delete rows, Excel is not keeping track of your last used cell but more like the high-water-mark so tries to print 3 or 4 pages in your case instead of one. If it does not match your data, including your use of formulas then you can reset for a single sheet using the MakeLastCell on my page http://www.mvps.org/dmcritchie/excel...m#MakeLastCell but you can fix all of your sheets at one time with Debra Dalgleish's macro Why do my scrollbars go to row 500 -- my data ends in cell E50?, http://www.contextures.com/xlfaqApp.html#Unused Warning: merged cells problems -- a merged cell has content only in the upper left cell of a merged cell group. If unfamiliar with macros, you will probably want to read how to install a macro you find in newsgroup or on a website, see http://www.mvps.org/dmcritchie/excel....htm#havemacro Do watch out that no one tried to do hidden calculations in an out of the way place on the worksheet, that simply spells trouble. Additional information: Fit Print to Page, and Adjustments to Layout Location: http://www.mvps.org/dmcritchie/excel/fitprint.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "dragonslay5" ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
Thank you David
That's a very complex solution to fix a very simple problem, now I remember why I hate Excel so much. "David McRitchie" wrote: Unless you have formulas in those cells that look empty, the problem is probably a "last used cell" problem. Use Ctrl+End to find the cell that Excel thinks is your last cell, which is the intersection of the rightmost used cell and the lowest down used cell. You can switch between formula view and values by using Ctrl+` (accent grave to left of number row) or by using Tools, Options, View, [x] formulas [view]. don't forget to uncheck formula view when done. What happens is that you insert rows, and you delete rows. When you delete rows, Excel is not keeping track of your last used cell but more like the high-water-mark so tries to print 3 or 4 pages in your case instead of one. If it does not match your data, including your use of formulas then you can reset for a single sheet using the MakeLastCell on my page http://www.mvps.org/dmcritchie/excel...m#MakeLastCell but you can fix all of your sheets at one time with Debra Dalgleish's macro Why do my scrollbars go to row 500 -- my data ends in cell E50?, http://www.contextures.com/xlfaqApp.html#Unused Warning: merged cells problems -- a merged cell has content only in the upper left cell of a merged cell group. If unfamiliar with macros, you will probably want to read how to install a macro you find in newsgroup or on a website, see http://www.mvps.org/dmcritchie/excel....htm#havemacro Do watch out that no one tried to do hidden calculations in an out of the way place on the worksheet, that simply spells trouble. Additional information: Fit Print to Page, and Adjustments to Layout Location: http://www.mvps.org/dmcritchie/excel/fitprint.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "dragonslay5" ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
I install the macros in my personal.xls and I run them from
organized toolbar menus. So simple for me. I never succeed trying to delete the excess rows and columns manually, but if you do, don't forget to save your file when you've done that. "dragonslay5" wrote in message ... Thank you David That's a very complex solution to fix a very simple problem, now I remember why I hate Excel so much. "David McRitchie" wrote: Unless you have formulas in those cells that look empty, the problem is probably a "last used cell" problem. Use Ctrl+End to find the cell that Excel thinks is your last cell, which is the intersection of the rightmost used cell and the lowest down used cell. You can switch between formula view and values by using Ctrl+` (accent grave to left of number row) or by using Tools, Options, View, [x] formulas [view]. don't forget to uncheck formula view when done. What happens is that you insert rows, and you delete rows. When you delete rows, Excel is not keeping track of your last used cell but more like the high-water-mark so tries to print 3 or 4 pages in your case instead of one. If it does not match your data, including your use of formulas then you can reset for a single sheet using the MakeLastCell on my page http://www.mvps.org/dmcritchie/excel...m#MakeLastCell but you can fix all of your sheets at one time with Debra Dalgleish's macro Why do my scrollbars go to row 500 -- my data ends in cell E50?, http://www.contextures.com/xlfaqApp.html#Unused Warning: merged cells problems -- a merged cell has content only in the upper left cell of a merged cell group. If unfamiliar with macros, you will probably want to read how to install a macro you find in newsgroup or on a website, see http://www.mvps.org/dmcritchie/excel....htm#havemacro Do watch out that no one tried to do hidden calculations in an out of the way place on the worksheet, that simply spells trouble. Additional information: Fit Print to Page, and Adjustments to Layout Location: http://www.mvps.org/dmcritchie/excel/fitprint.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "dragonslay5" ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reduce my document to one page?
When you've set Print Area, and Page Setup, those settings remain when you
save the document, and will apply when you reopen the document. -- David Biddulph "dragonslay5" wrote in message ... Thanks David but I want to change my document to only be one page. Maybe I phrased my question badly. I want to permenantly resave my document as a one page only document. dragonslay5 "David Biddulph" wrote: Set the Print Area to cover just your used cells. If it spreads to more than one page after that, Page Setup/ Page will let you fit to one page. -- David Biddulph "dragonslay5" wrote in message ... I have several excel documents that are three or four pages long but only have cells on page one. Everytime I print out I have to change my printer settings to page 1 only so I do not print out three blank pages. How do I reduce my document to one page? Thanks to everyone who replies! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page break says it has been inserted but does not respond | New Users to Excel | |||
Fixing a Total on a page | Excel Worksheet Functions | |||
How do I delete page 2 of a 2-page document? | New Users to Excel | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
Automatically Saving an Excel Document as a Web Page | Excel Discussion (Misc queries) |