Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Deleting Cells

Recently I have noticed when I select cells and hit the delete button,
Excel takes a long time to process and locks up for a time. I noticed
it first in macros that select all cells in a workbook and delete. I
recently had a workbook that had gotten large despite having mainly
"blank" cells. I deleted the cells and it froze for 30 seconds or so.
Any ideas of what could cause this? Also any suggestions on the best
way to delete unwanted cells?

I am using:
Excel 2003
WindowsXP Profesional


Thanks - Michael
 
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
Deleting all cells that appear more than once Johnny Excel Discussion (Misc queries) 5 November 2nd 07 05:03 PM
deleting cells JULZ New Users to Excel 1 August 21st 06 04:59 PM
deleting unused cells / getting rid of inactive cells Woody13 Excel Discussion (Misc queries) 3 January 26th 06 09:11 PM
Deleting cells within a row Pablo Excel Discussion (Misc queries) 1 July 11th 05 08:41 PM
Deleting #N/A from cells... Jambruins Excel Discussion (Misc queries) 3 February 22nd 05 11:36 PM


All times are GMT +1. The time now is 04:28 PM.

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"