Thanks Rojee, worked well.
"Rojee" wrote:
Select the data range...
select Edit..then Go to..specials or (ctrl G, then special)
select Blanks then click Ok...proceed to delete operation
-----Original Message-----
I have a spreadsheet with data in column 1.
every other row is empty, I would like to delete this
rows in order to
compact my data.
Thanks.
.
|