Can't unhide a column
Windows 10 My column C which I hid last week now won't unhide. I've tried right-clicking unhide, select all unhide, visibility, reformatting all the column widths: nothing works.
Forum Discussion
If you do this:
Press F5, type C:C, click OK and then select (Start tab) Format, Column width and set it to e.g. 10, does it show?
is View, Freeze panes set by any chance?
Press F5, type C:C, click OK and then select (Start tab) Format, Column width and set it to e.g. 10, does it show?
is View, Freeze panes set by any chance?
- I followed your suggestion and went to View. Freeze panes. Cleared all and voila! column A re-appeared.
Kisses JKPieterse - it was freeze panes for my file. I would not have found it without this thread.
- Freeze Panes...great tip! It works for me too after far too much time scouring help threads. Thank you!!!
JKPieterse Thanks a lot, unfreezing solved the problem.
I don't understand what C:C or F5 does - I don't get to a Format option on the Start Tab
using Excel as a app with Office 365
- The F5 function key on the keyboard opens the Goto dialog (also available by clicking the looking-glass button on the Home tab), in which the user was asked to type C:C, the address of column C. The Home tab should have a Format button (in English Excel), it has been there for over 16 years.
