Freezing Multiple Columns in Excel

Question

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.

Answer 1

If you want to freeze Row1 and Column A&B, Select the C2 and click Freeze Panes.

Answer 2

On the View tab of the ribbon, click the Freeze Panes drop down.

If the first item is Unfreeze Panes, select that.

Select cell C2 (the cell below the first row and to the right of the first two columns).

Click the Freeze Panes drop down and select Freeze Panes.

Answer 3

Hello, thanks for the quick response. Unfortunately this does not freeze the panes, it will freeze the panes to the right of the column selected, but not the left, strangely enough.

Answer 4

Hello, thanks for the quick response. Unfortunately this does not freeze the panes, it will freeze the panes to the right of the column selected, but not the left, strangely enough.

Answer 5

Are you using show sheet right to left? Could you share us a screenshot of your issue?