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

Excel 2002: Request to speed up deleting blank cells
 

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

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

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

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

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

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