Hi,
I am trying to lock one half of my sheet (columns A thru J) while the rest of the columns/rows can be scrolled through. I clicked right of the last column that I wanted to lock and selected freeze panes and nothing changed except a gray line now appearing. I also tried splitting the sheet and that didn't accomplish anything either. Splitting and freezing work horizontally on rows on the same sheet but not vertical on columns for some reason.
Any idea what's going here and how I can address it?
I am trying to lock one half of my sheet (columns A thru J) while the rest of the columns/rows can be scrolled through. I clicked right of the last column that I wanted to lock and selected freeze panes and nothing changed except a gray line now appearing. I also tried splitting the sheet and that didn't accomplish anything either. Splitting and freezing work horizontally on rows on the same sheet but not vertical on columns for some reason.
Any idea what's going here and how I can address it?