How to save hidden columns to a temporary view

Question

My organization uses a huge excel workbook to track progress of submitted applications for services. My role is to add new applications to the spreadsheets, but I only populate a few columns that are spread throughout the spreadsheet, with many columns in between that I have to scroll past.

I'd like to set up a temporary view that allows me to see just the columns I need to populate, which would save a ton of time. I set up a temp view, but the hidden columns don't seem to stick. They turn off when I exit the temp view, but don't auto-hide when I turn it back on again. Am I missing something?

Answer 1

Did you create a "Normal" view before as I did?

Andreas.

Answer 2

I did not initially, but I did just try that and it still didn't work. It looks like we're using different versions of Excel, but the steps are the same. I:

1- opened the workbook

2- created a new view called "Normal" and hit "keep"

3- hid the rows I don't want to see

4- created a new view called "Test" with columns still hidden and hit "keep" - columns are still showing hidden

5- toggled to "normal" and columns unhide

6- toggled back to "Test", but columns didn't hide

Answer 3

2- created a new view called "Normal" and hit "keep"

Please make a screenshot where you hit "keep" and post it here.

A "keep" button is not part of the official documentation:
https://support.microsoft.com/en-us/office/create-apply-or-delete-a-custom-view-ce722bf9-0b4a-49a5-94ba-438fde18fc2b

Andreas.