Forum Discussion
Deleted
Jun 20, 2018Can'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.
JKPieterse
Jun 21, 2018Silver Contributor
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?
- HerbertEAug 27, 2024Copper Contributor
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
- JKPieterseAug 28, 2024Silver ContributorThe 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.
- bhaveshrikantAug 25, 2021Copper Contributor
JKPieterse Thanks a lot, unfreezing solved the problem.
- ShahinHunekeApr 07, 2021Copper ContributorFreeze Panes...great tip! It works for me too after far too much time scouring help threads. Thank you!!!
- Jenny_s745Jan 07, 2021Copper Contributor
Kisses JKPieterse - it was freeze panes for my file. I would not have found it without this thread.
- KathyBSJul 16, 2020Copper ContributorI followed your suggestion and went to View. Freeze panes. Cleared all and voila! column A re-appeared.