Forum Discussion
Is there a way to delete every-other cell going up or down in a single column? Every other row?
Hi, I have a long list (700+) of prices to paste into a column, but every-other row is blank. How can I delete it? Can I delete every other cell in a column? Can I delete every other row on a sp...
Select the entire range, then sort it on a column that has data in every other row. The empty rows will move to the bottom.
Or:
Select a column with data in every other row.
Press F5 to activate the Go To dialog.
Click Special...
Select Blanks, then click OK.
On the Home tab of the ribbon, in the Cells group, select Delete > Sheet Rows.