Freezing Multiple Columns in Excel

Anonymous
2023-06-01T15:50:19+00:00

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.

0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Anonymous
    2023-12-19T01:16:03+00:00

    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!

    83 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2024-01-31T17:44:09+00:00

    This worked! Thanks

    5 people found this answer helpful.
    0 comments No comments