View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim Shnell Tim Shnell is offline
external usenet poster
 
Posts: 11
Default How do I delete blank rows (rows alternate data, blank, data, etc

On Jun 26, 1:10 pm, ncochrax
wrote:
I am looking for a shortcut to delete multiple blank rows (rows alternate as
follows: data, blank, data, blank, etc.) Is there a way to delete the blank
rows between the data rows without having to select each row individually
using CNTRL-C?


Selecting all of your data and sorting it by any of your columns
should move all of the blank rows to the bottom.