Excel 2002: Request to speed up deleting blank cells


M

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
 
Ad

Advertisements

M

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
 
B

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top