Forum Discussion
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 hav...
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.