Forum Discussion
Jenny_2663
Aug 20, 2024Copper Contributor
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 spreadsheet?
Please advise,
Thank you
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.
- mathetesSilver ContributorThere no doubt are several methods. I would use the FILTER function to derive only cells with some value greater than zero. Then paste the resulting column.