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)?

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)?

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)?

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)?

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)?