Forum Discussion

Jenny_2663's avatar
Jenny_2663
Copper Contributor
Aug 20, 2024

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

 

  • Jenny_2663

    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.

  • mathetes's avatar
    mathetes
    Silver Contributor
    There 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.

Resources