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