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.
|