View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default 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