View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mePenny mePenny is offline
external usenet poster
 
Posts: 38
Default REMOVING A HUGE AMOUNT OF BLANKS ROWS

I tried to use "F5, Special, Blank, okay, Edit, Delete, Entire Row" but it
tells me " Selection to large" and stops.

With the blank rows going every other one, the file is 15850 rows long, only
3 columns wide.

Is there a formula that will handle such a large amount of rows?

mePenny