Delete all data (formulas) below a desired row.
 

In Excel 2000, I somehow propagated a formulab to over 60,000 rows. Is there
a shortcut to clear a large unwanted area?

In the name box (above row 1 left of column A), type in the the range you
want to delete, assume you wanted 15 rows of formulas and want to delete row
16 row 65336, place cursor (mouse click) in the name box and type 16:65536
and press enter, then do editdelete, press ctrl + home and save the workbook


Regards,

Peo Sjoblom


"JMSimms" wrote:

In Excel 2000, I somehow propagated a formulab to over 60,000 rows. Is there
a shortcut to clear a large unwanted area?

Select the row below where you want the last row of data.

Then SHIFT + END + DownArrow.

EditDeleteEntire Row.


Gord Dibben Excel MVP

On Mon, 16 May 2005 09:41:06 -0700, "JMSimms"
wrote:

In Excel 2000, I somehow propagated a formulab to over 60,000 rows. Is there
a shortcut to clear a large unwanted area?