Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print only the used portion of excel spreadsheet?
When printing a 5 page excel spreadsheet, printer wants to print 1200 pages.
Can I get it to print only the pages with data (the first 5)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print only the used portion of excel spreadsheet?
What happens if you press <Ctrl<End? Bet you it goes way past your last
cell? If so, go to the last cell, and delete the rows below that, as well as the columns to the right of it. Save your file and try again. -- kassie never stop learning "brw" wrote in message ... When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print only the used portion of excel spreadsheet?
did you set the print area? if not, highlight just the area you want to print
then set the print area. file/print area/set print area do a print preview then go to setup and you can set it to print 1 wide by 5 tall. check your page break preview also. "brw" wrote: When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print only the used portion of excel spreadsheet?
How do you delete in 2 directions at once? Also, how do you delete infinite
space? "Kassie" wrote: What happens if you press <Ctrl<End? Bet you it goes way past your last cell? If so, go to the last cell, and delete the rows below that, as well as the columns to the right of it. Save your file and try again. -- kassie never stop learning "brw" wrote in message ... When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print only the used portion of excel spreadsheet?
Excel has 256 columns and 65536 rows so space is not "infinite".
This is a multi step deletion. Go to bottom of your data range. SHIFT + END + DownArrow to select to row 65536. EditDeleteEntire Row. Got to right of your data range and SHIFT + END + RightArrow. EditDeleteEntire Column. IMPORTANT.............at this point FileSave. In some versions it is necessary to Save, Close and re-open to see changes. Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 11:40:02 -0700, brw wrote: How do you delete in 2 directions at once? Also, how do you delete infinite space? "Kassie" wrote: What happens if you press <Ctrl<End? Bet you it goes way past your last cell? If so, go to the last cell, and delete the rows below that, as well as the columns to the right of it. Save your file and try again. -- kassie never stop learning "brw" wrote in message ... When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print odd pages only from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Why do gridlines not print in Excel spreadsheet? | New Users to Excel | |||
How do I print individual envelopes from a excel spreadsheet? | Excel Discussion (Misc queries) | |||
I cant see my excel spreadsheet but only in Print Preview? | Excel Worksheet Functions | |||
How do I put a button on an excel spreadsheet to print a report? | Excel Discussion (Misc queries) |