Opening Hidden Columns in Excel Sheet

rwmill9716

Active Member
Joined
May 20, 2006
Messages
429
I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,035
Office Version
365
Platform
Windows
Try changing the column widths.
 

rwmill9716

Active Member
Joined
May 20, 2006
Messages
429
Thanks, I was able to expose the whole sheet using the following macro:

Sub UnhideAllColumns ()
Cells.EntireColumn.Hidden = False
EndSub
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,035
Office Version
365
Platform
Windows
Glad you sorted it & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,692
Messages
5,470,171
Members
406,684
Latest member
MAKEMELOL

This Week's Hot Topics

Top