Why Del is Slow
 

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

Why Del is Slow
 

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


"Ananth" wrote in message
...
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

Why Del is Slow
 

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

Ananth wrote:

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