View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JERRY JERRY is offline
external usenet poster
 
Posts: 6
Default Clearing cells takes long, long time

I have the same problem with Excel 2003. Anyone can help?

"unclemuffin" wrote:

I am using Excel 2007 and I have a sheet that has about 22,000 rows of
data. When I try to delete the data by all of the following methods
it takes well over three minutes to complete:

Highlight the data range and press the delete key
Highlight the data range and click Home, Clear, All or Home, Clear,
Contents
Hightlight the rows and press delete key of right click and delete
rows

How can I speed this up?

Brent