How do I delete blank rows (rows alternate data, blank, data, etc

[Guest]

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?

 

[Tim Shnell]

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.

 

[Guest]

you could also use the autofilter to filter for blanks, then delete the
filtered rows, turn off autofilter.

or, select one of your columns, Edit/Goto/Special - blanks, which will
select the blank cells and then delete the rows.

be sure to keep a backup before you try any suggestion that is new to you
(if your data is important, you should already have it backed up).