Easy way to delete columns?

  • Thread starter Thread starter Chris Miller
  • Start date Start date
C

Chris Miller

I've got a workbook with 5 sheets in it. Each sheet has a large number of
columns. On some of the columns, there is no data on the whole sheet except
for row 1 (the header, or title of the column). Is there an easy way I can
tell Excel to remove the columns that have no data on any row (except row
1)? Excuse my ignorance, I'm not sure if there is some backend interface or
"language" (like SQL maybe?) or something that could take care of something
such as this.

-ee99ee
 
On each sheet, assuming you can use row 2 to determine delete / not delete based
on blank / not blank. Select the whole of row 2 by clicking on the row header
at the left. Do Edit / Go To / Special / Blanks, then do Edit / Delete / Entire
Column.

Just repeat on the other 4 sheets.
 
Wow... you guys really know you're Excel (wonder why, it being an Excel
newgroup and all :P). Thanks!!

-ee99ee
 
Back
Top