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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter by typed value 5
Unobtrusive Place To Put Report TItle and a List? 5
moving rows to another sheet 3
Selecting Rows for Copying 3
Excel Help to copy information from one row at a time to another sheet 1
Advanced Vlookup Formula 2
lookup and return column number 2
Single column to multiple columns 5

Back
Top