LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Clearing cells takes long, long time

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading MS Query takes a long time TonyL Excel Worksheet Functions 0 August 14th 06 08:30 AM
Excel Help takes a very long time to load Sam Pack via OfficeKB.com Excel Discussion (Misc queries) 4 March 4th 06 12:02 AM
Save takes long time Jan Excel Discussion (Misc queries) 2 February 15th 06 06:01 PM
Edit query takes a long time TonyL Excel Worksheet Functions 0 May 11th 05 10:50 PM
Excel file takes a long time to save ben@bikecenturies Excel Discussion (Misc queries) 1 February 3rd 05 12:27 AM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"