Removing blank rows

R

rilo1970

I thought I had done this before, but I have a spreadsheet with a blan
row between each entry and I need to remove these blank rows. I thin
I can do it by placing the data in a pivot table, but is there a
easier or alternative way to remove blank rows
 
J

JulieD

Hi

one option, sort the data (select area and use data / sort) and sort
descending - this will put all the blank rows at the bottom

(before trying anything like this, please take a backup of your workbook)

Cheers
JulieD
 
C

Cesar Zapata

one way.

Select your column or the first column of your range ie a1:a150 then
press F5 then Specials> Blanks> OK. it will select all the blanks then
just right click on a blank and choose delete > entire row.



Cesar Zapata
 
Top