Delete all data (formulas) below a desired row.

J

JMSimms

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

Peo Sjoblom

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 edit>delete, press ctrl + home and save the workbook


Regards,

Peo Sjoblom
 
G

Gord Dibben

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

Then SHIFT + END + DownArrow.

Edit>Delete>Entire Row.


Gord Dibben Excel MVP
 
Top