Forum Discussion
Unhide columms???
I hide columns and made some changes to the document. Saved the doc and when I came back later the columns are still hidden. How do I unhide them?
4 Replies
Kwlambeth
If you want it to automatically unhide then you need vba to do this, like my project.
Inside ThisWorkbook: Private Sub Workbook_Open()
insert - Range("A:E").Select (this selects columns A to E)
Selection.EntireColumn.Hidden = TrueHope this helps
- addendum:
change A & E with your hidden columns..
- Lets say you hid column H or if multiple H,I, and J. At the top of the column bar you will see a compressed column (It will not show letters, but you will see a mini column in the bar but not in the spreadsheet), simply right click on it and click 'unhide' and of course save so the change will be stored when you exit
Select columns with hided ones in between, right click on selection and Unhide
