Dec 29 2022 11:44 AM
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?
Dec 29 2022 12:34 PM
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.