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?