Excel 2002: Request to speed up deleting blank cells

[Mr. Low]

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/com...1-c282d3c3438f&dg=microsoft.public.excel.misc

 

[Don Guillett]

What method are you using?

 

[Mr. Low]

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

 

[Bob I]

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]

Hi Bob,

Thanks for your reply.

My Auto calculate is always on.

Thanks

Low

 

[Bob I]

Does turning it off make any improvement?

 

[Mr. Low]

Hi Bob,

No.

Thanks

Low

--
A36B58K641

Does turning it off make any improvement?