Unhiding columns

Copper Contributor

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?

1 Reply


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.