Forum Discussion

Deleted's avatar
Deleted
Jun 20, 2018

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.

16 Replies

  • MarielleL1400's avatar
    MarielleL1400
    Copper Contributor

    The only thing that worked for me was View -> Page Layout and then of course back to Page -> Normal.

    • alaaalgammal's avatar
      alaaalgammal
      Copper Contributor
      Thanks for your help < changing the page layout to normal did the trick !!
  • jamesnotjim's avatar
    jamesnotjim
    Copper Contributor
    It was Freeze Panes for me as well. Unfreezing panes unhid all of the previously hidden columns. I'm running Microsoft Excel for Mac (v.16.69.1) on macOS Monterey (v.12.6.3).
  • saddle_monkey's avatar
    saddle_monkey
    Copper Contributor

    For me it was that the scroll area had been defined. I had to go into module properties and remove the ScrollArea region.

  • kofaxeric's avatar
    kofaxeric
    Copper Contributor
    For me, it was because the sheet was protected. I asked the owner for an unprotected (no password) sheet and was able to unhide things again.
  • Kav1025's avatar
    Kav1025
    Copper Contributor
    For anyone else who this might not have worked for, chances are that the missing columns may have been minimized. With your mouse, try grabbing the bar along the left edge of the last column that is visible. Hold down the right mouse button (you will see a double arrow pop up) and drag it to the right. The missing columns should show up.
  • JKPieterse's avatar
    JKPieterse
    Silver 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?
    • HerbertE's avatar
      HerbertE
      Copper Contributor

      JKPieterse 

      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

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        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.
    • ShahinHuneke's avatar
      ShahinHuneke
      Copper Contributor
      Freeze Panes...great tip! It works for me too after far too much time scouring help threads. Thank you!!!

Resources