I found out a workaround for freezing additional columns. After you freeze the first column, insert a column to the left of the frozen column. This will freeze the first two columns. Though, you might have to cut and paste the data into the new columns. Hope this helps!
Freezing Multiple Columns in Excel
Hello,
I'm trying to have my top row, and my first two columns in the spreadsheet I'm working on. I only have the option (in the desktop and the web app) to freeze the top row and the first column. I've ran into other issues like this before, that seem like they should be really straightforward but are either impossible to do or buried under a messy UI. I'm using the latest version of office 365.
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
7 answers
Sort by: Most helpful
-
Anonymous
2023-12-19T01:16:03+00:00 -
Anonymous
2024-01-31T17:44:09+00:00 This worked! Thanks