How to print only the used portion of excel spreadsheet?

[Guest]

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

 

[Kassie]

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.

 

[Guest]

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.

 

[Guest]

How do you delete in 2 directions at once? Also, how do you delete infinite
space?

 

[Gord Dibben]

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.

Edit>Delete>Entire Row.

Got to right of your data range and SHIFT + END + RightArrow.

Edit>Delete>Entire Column.

IMPORTANT.............at this point File>Save.

In some versions it is necessary to Save, Close and re-open to see changes.


Gord Dibben MS Excel MVP