Why Del is Slow

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

Guest

I am handling a worksheet that has 30000 rows. I use the DEL key to delete
the row, instead of using Delete Rows Command in the EXcel Menu.

Excel is annoyingly slow and sometimes does not respond.

What is the solution

Ananth
 
Ananth,

A lot depends on what you don't say..

Set Excel's calculation mode to manual....
Use a macro...
Sort the table on your deleting key, and delete all the rows as one block....
Remove links...
Convert formulas to values...

HTH,
Bernie
MS Excel MVP
 
Perhaps try turn off Automatic Calculation, and see if that is what is
using the time.
 
Back
Top