B
Bill
I Quick print a document from server. There are 20 pages printed but only 4
pages exist in the worksheet. How does this happen?
pages exist in the worksheet. How does this happen?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
It could be that your print range is wrong.
File|Print area
(in xl2003 menus)
Or it could be that your used range isn't what you expect, so excel wants to
print everything.
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused
For a couple of techniques of resetting that last used cell.
File|Print area
(in xl2003 menus)
Or it could be that your used range isn't what you expect, so excel wants to
print everything.
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused
For a couple of techniques of resetting that last used cell.
B
Bill
I am using office/XL2007, I tried your suggestions, including going to
Debra's page but to no avail. In the other worksheets in the file, Quick
Print shows the correct number of pages as they exist in the worksheet -
except the one worksheet I am needing. There are olny 4 pages in it but the
Quick Print preview and print gives 20 pages. Using the Print drop down and
selecting Print to choose the printer, etc gives me 1 print of the 4 pages.
even the Quick Print setup shows 1 copy - but of 20 pages, not 5 copies. [I
should have worded this problem more clearly]. Dave, does this bring up any
ideas? Another way to express it is -in the worksheet I have 4 pages; when I
preview and quick print XL says there are 20 pages. I tried the suggestion to
delete balnk rows/columns but no change.
Debra's page but to no avail. In the other worksheets in the file, Quick
Print shows the correct number of pages as they exist in the worksheet -
except the one worksheet I am needing. There are olny 4 pages in it but the
Quick Print preview and print gives 20 pages. Using the Print drop down and
selecting Print to choose the printer, etc gives me 1 print of the 4 pages.
even the Quick Print setup shows 1 copy - but of 20 pages, not 5 copies. [I
should have worded this problem more clearly]. Dave, does this bring up any
ideas? Another way to express it is -in the worksheet I have 4 pages; when I
preview and quick print XL says there are 20 pages. I tried the suggestion to
delete balnk rows/columns but no change.
D
Dave Peterson
And what happened when you changed the print area?
I am using office/XL2007, I tried your suggestions, including going to
Debra's page but to no avail. In the other worksheets in the file, Quick
Print shows the correct number of pages as they exist in the worksheet -
except the one worksheet I am needing. There are olny 4 pages in it but the
Quick Print preview and print gives 20 pages. Using the Print drop down and
selecting Print to choose the printer, etc gives me 1 print of the 4 pages.
even the Quick Print setup shows 1 copy - but of 20 pages, not 5 copies. [I
should have worded this problem more clearly]. Dave, does this bring up any
ideas? Another way to express it is -in the worksheet I have 4 pages; when I
preview and quick print XL says there are 20 pages. I tried the suggestion to
delete balnk rows/columns but no change.
D
Dave Peterson
And what cell is selected when you hit ctrl-end.
That's what excel thinks is the bottom right corner of the used range.
That's what excel thinks is the bottom right corner of the used range.
I am using office/XL2007, I tried your suggestions, including going to
Debra's page but to no avail. In the other worksheets in the file, Quick
Print shows the correct number of pages as they exist in the worksheet -
except the one worksheet I am needing. There are olny 4 pages in it but the
Quick Print preview and print gives 20 pages. Using the Print drop down and
selecting Print to choose the printer, etc gives me 1 print of the 4 pages.
even the Quick Print setup shows 1 copy - but of 20 pages, not 5 copies. [I
should have worded this problem more clearly]. Dave, does this bring up any
ideas? Another way to express it is -in the worksheet I have 4 pages; when I
preview and quick print XL says there are 20 pages. I tried the suggestion to
delete balnk rows/columns but no change.