Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ONE PAGE REPORT WANTS TO PRINT 1311 pages in each copy, WHY?
The excel report is only one page but recognizes it as 1311 pages long, why.
Nothing shows on pages other than page one. |
#2
|
|||
|
|||
Re-set your print area.
-- Don Guillett SalesAid Software "G'pa Woody" <G'pa wrote in message ... The excel report is only one page but recognizes it as 1311 pages long, why. Nothing shows on pages other than page one. |
#3
|
|||
|
|||
Woody
Check your print range settings. FilePrint Area. Clear it first then reset to your desired range. Try the following method to reset the used range of your sheet. Excel often over-estimates the actual "used range" due to data being entered then deleted. Where does CTRL + END take you? If far below and to the right of what you know is your real used range, go to the row after the last row of real data then SHIFT + END + DownArrow to select all rows below your data. Now..........EditDeleteEntire Row(do not just clear contents, delete) Do same for columns to the right of your data. NOW IMPORTANT...Save the workbook. Close and re-open to see changes. Hit CTRL + END to see that the used range is what you set it for. Gord Dibben Excel MVP On Tue, 10 May 2005 08:22:02 -0700, "G'pa Woody" <G'pa wrote: The excel report is only one page but recognizes it as 1311 pages long, why. Nothing shows on pages other than page one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
need to reducing pages....i need to put the bottom part of a page. | Excel Discussion (Misc queries) | |||
print selected sections on the same page | Excel Discussion (Misc queries) | |||
Can I print 2 pages on 1 page? | Excel Discussion (Misc queries) |