View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Is there an easy way to delete empty columns?

hi, !

I am using Excel 2007.
I have a spreadsheet that has been exported from an in-house software database.
It has 57 columns and more than 1,000 rows. A lot of the columns are totally blank.
Other than finding them manually is there an easier way to delete them?


1) select the entire row (say) of your titles
2) {F5} (button) special... blank cells accept
3) right-click delete... entire column

hth,
hector.