ExcelBanter - deleting every other row in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - deleting every other row in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/125047-deleting-every-other-row-excel.html)

RuthZ

deleting every other row in Excel

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

Gord Dibben

deleting every other row in Excel

Select a column then F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 20:50:01 -0800, RuthZ
wrote:

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

RuthZ

deleting every other row in Excel

Thanks!

"Gord Dibben" wrote:

Select a column then F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 20:50:01 -0800, RuthZ
wrote:

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

All times are GMT +1. The time now is 05:22 PM.