deleting every other row in Excel

G

Guest

I have a spreadsheet with copy and pasted information. The information
includes a blank row between data rows. Is there a formula I can use to
eliminate the blank rows?
Thanks,
RuthZ
 
G

Gord Dibben

Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting/removing unused rows in a worksheet 3
Insert Cells every other row 1
Deleting blank rows 4
How do I insert a row after every row of data in XL? 5
Deleting Blank Rows. 3
Deleting 63,886 Blank Rows Under My Data 15
copy every 3rd row to empty rows below 3
Copy & Paste 2

Top