How to remove blank columns from a large spreadsheet

[SEMMatt]

Hello,

I have a large workbook of over 255 columns. How can I quickly find and delete any columns with no data in them and thereby attempt to shrink the size of my workbook?

Thank you

[cbatrody]

Hi,

It can be easily done by selecting the blank columns at once and deleting them.

Please go through the following URL-

http://www.extendoffice.com/document...y-columns.html

[newdoverman]

Be careful when using the directions from www.extenoffice.com. If there are blank cells in any of the other columns, those columns will be deleted along with the completely empty ones because of the selection of empty cells. (I tested this a few times)

[cbatrody]

Instead of selecting the whole data range, just select the top row where you 100% know the columns that need to be deleted -

Find - Go To Special -> select "Blanks" -> Ok -> the blank cells in the selected row will get highlighted -> press "CTRL" & "- " together (or right click and delete in one of the selected cells) -> Choose "Entire Column" -> Ok.

This way you avoid any unwanted deletion which may occur because of blank cells in between the data range.

[samba_ravi]

Go to the last cell in 1st Column .i,e Column A
=IF(COUNTA(OFFSET(A$1,0,0,ROW()-1,1))=0,"",1) enter this formula
and copy towards right
then select that entire row
Press F5 key
select "Special"
then Click on Formula then select text only under Formula
Press OK
now it select all the cell with blank column
delete that columns
delete the entire row which you entered formula