Delete all data (formulas) below a desired row.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Regards,

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

Then SHIFT + END + DownArrow.

Edit>Delete>Entire Row.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete duplicate entries in a large worksheet 6
Question about copying long rows of data 2
Excel Help to copy information from one row at a time to another sheet 1
how do i parse every nth data point from a large data set in exce 1
Problems copying Large Amounts of Data in Excel 2007 1
Formula extends down to rows past data - very slow opening 4
How do I remove empty Rows 2
How do I filter a worksheet by every 60 rows in excel 3

Back
Top