Removing Columns on a Worksheet?

[bdunk]

Hello,
I would like to be able to remove all columns in a worksheet but three. Is this possible? I would just like columns A,B, and C. I do not want Excel to repopulate the area where other columns have been removed. Thanks in advance

Bdunk

 

[irazer]

When I need to omit columns I select all the colums I do not want and hide them. i.e., Select columns, go into format then column, then hide.

Hope that helps

 

[bdunk]

Irazer, thanks for the reply. The problem is that it constantly repopulates the area. I just want three columns of cells thats it.

Thanks again bdunk

 

[applebyd]

Irazers method seems to work for me.

It just leaves Col's A,B and C all the rest is a Grey sheet.

You do need to select Cols D to IV.

Good Luck

:wink:

 

[bdunk]

All, I stand corrected. I did not realize that IV was the end. I thought it was infinite. I got it to work. Thanks so much.

bdunk