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.
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.
@Hans Vogelaar So...I unfreeze panes and those are still the only options that I get...and none of them will freeze both the rows and columns at the same time...am I just not fully awake yet? lol