Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Hi,
I notice that it normally takes 12-15 seconds or longer to delete blank cells selected from a large block of data of 35,000 rows with altenate empty rows. If MS could upgrade the software to enable the job done much faster, it would be great. I do not know how fast is Excel 2007 could do the similar job. Appreciate very much if MS could see if it need improvement. Thanks Low -- A36B58K641 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Hi Don,
I highlight A1: A35000 and then use F5 Special Select Blanks and delete rows. I am not using sorting to eliminate the blanks because I need to preserve the original row sequence. Thanks Low -- A36B58K641 "Don Guillett" wrote: What method are you using? -- Don Guillett Microsoft MVP Excel SalesAid Software "Mr. Low" wrote in message ... Hi, I notice that it normally takes 12-15 seconds or longer to delete blank cells selected from a large block of data of 35,000 rows with altenate empty rows. If MS could upgrade the software to enable the job done much faster, it would be great. I do not know how fast is Excel 2007 could do the similar job. Appreciate very much if MS could see if it need improvement. Thanks Low -- A36B58K641 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Is Auto Calculate turned off? Also, the earliest supported version of
Excel is 2003. you won't be seeing any patches for 2002. Mr. Low wrote: Hi Don, I highlight A1: A35000 and then use F5 Special Select Blanks and delete rows. I am not using sorting to eliminate the blanks because I need to preserve the original row sequence. Thanks Low |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Hi Bob,
Thanks for your reply. My Auto calculate is always on. Thanks Low -- A36B58K641 "Bob I" wrote: Is Auto Calculate turned off? Also, the earliest supported version of Excel is 2003. you won't be seeing any patches for 2002. Mr. Low wrote: Hi Don, I highlight A1: A35000 and then use F5 Special Select Blanks and delete rows. I am not using sorting to eliminate the blanks because I need to preserve the original row sequence. Thanks Low |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Does turning it off make any improvement?
Mr. Low wrote: Hi Bob, Thanks for your reply. My Auto calculate is always on. Thanks Low |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Request to speed up deleting blank cells
Hi Bob,
No. Thanks Low -- A36B58K641 "Bob I" wrote: Does turning it off make any improvement? Mr. Low wrote: Hi Bob, Thanks for your reply. My Auto calculate is always on. Thanks Low |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed of Excel When Inserting & Deleting Rows | Excel Discussion (Misc queries) | |||
Excel 2002 : How to speed up opening of XML file ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to speed block cells ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Problem in moving along blank cells | Excel Discussion (Misc queries) | |||
Excel 2002 : Is there any speed fill formula ? | Excel Discussion (Misc queries) |