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

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?