Delete unwanted columns that dont have data below the column header row

[AKS0305]

Excel Forum.png


Hi, where I work we extract these large reports that contain columns where half of the columns are empty beneath the column header, and so we don't need those and per the company, there is no way to fix this issue. Is there an easy way to delete unwanted columns that have a column header but are empty beneath the first row (column header) ? I would not like to delete the column header as much of our info is coded so we need those.

I've included a screenshot.

Thanks!

[63falcondude]

Hello and welcome to the forum.

This part is confusing me:

Is there an easy way to delete unwanted columns that have a column header but are empty beneath the first row (column header) ?

I would not like to delete the column header

If you have a column that is completely blank other than the column header, and you don't want to remove the whole column (since you want to keep the header) what is there to remove?

[AKS0305]

I don't mind removing the entire column, I just do not want to have to go though the sheet and manually select columns and then delete them.

[63falcondude]

In that case, try this:

Highlight all of your data > Find & Select > Go To Special > Blanks > OK > Right click on any of the selected cells > Delete > Entire column > OK

[AKS0305]

It worked! Thank you!!