Forum Discussion
How to freeze Rows & columns at the same time
Apparently, Freeze Panes is already active.
So first select Unfreeze Panes from the Freeze Panes dropdown.
Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.
If the first item in the Freeze Panes drop down is Unfreeze Panes, select that.
Select the cell below the last row that you want to keep visible, and to the right of the last column that you want to keep visible.
So for example, if you want to freeze the first row and first column, select cell B2.
And if you want to freeze the first two rows and the first three columns, select cell D3.
Then select Freeze Panes > Freeze Panes.
HansVogelaar Hello, I only have these options available:
Up to now, this discussion was about the desktop version of Excel.
My guess is that your screenshot is from the online (browser) version of Excel.
The wording of the options is different from the desktop version, and will change depending on the active cell.
"Freeze at selection" will freeze the rows above the active cell and the columns to the left of the active cell.
"Top Row" will freeze row 1.
"Up to row 3" means that the active cell is in row 4; the rows above it will be frozen.
If the active cell is in row 6, the item will read "Up to row 5".
"First column" will freeze column A.
"Up to column A" means that the active cell is in column B; the column to the left will be frozen.
If the active cell is in column D, it would read "Up to column C".
- HansVogelaar
You are correct, I'm sorry, I should have said. I am using the browser version. So, basically the browser version does not have that option is what you are saying? Thanks for the quick response!You can do exactly the same things in the browser version as in the desktop versiom, but the items are worded differently.