This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
If you want to freeze Row1 and Column A&B, Select the C2 and click Freeze Panes.
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!
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.
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.
Are you using show sheet right to left? Could you share us a screenshot of your issue?