Forum Discussion

David_E_Varga's avatar
David_E_Varga
Copper Contributor
Dec 29, 2022

Unhiding columns

I have a multi-year weekly budget spreadsheet.  I have hidden columns from 1915 to the end of 2022 and have continued visible data into 2023.   How do I unhide a limited number of columns without having to unhide the full spreadsheet?

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 29, 2022

    David_E_Varga 

    Let's say you want to unhide columns W to AB.

    Press F5 or Ctrl+G to display the Go To dialog.

    Enter W:AB in the box and press Enter or click OK.

    On the Home tab of the ribbon, select Format > Hide & Unhide > Unhide Columns.

    You can also unhide non-adjacent columns. For example, enter P:R,U:U,Z:AB in the box.

Resources