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