Why Del is Slow

[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

 

[Bernie Deitrick]

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

 

[Bob I]

Perhaps try turn off Automatic Calculation, and see if that is what is
using the time.