View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default How do I delete multiple empty columns in Excel at one time?

Hi Cindy,
Maybe save a copy of the original or try this on a small sample first.
How about this:
-Select Row 1
-Click on the Edit menu, click on Go To...
-Click on the Special... button and select Blanks
-Then click on the Edit menu again, select Delete and then choose Entire
column.

--
Hope this helps,
MarkN


"Cindy C" wrote:

I exported data from QuickBooks, but about every other column is blank. I'm
having trouble sorting the data with all of the empty columns. Since I have
12 different worksheets with this problem, I really would like to know how to
take out all of the empty columns at one time without having to highlight and
delete each column separately.