Forum Discussion
Excel Web App - freeze BOTH first row and first column AT THE SAME TIME
RE: MS Excel WEB APP Can someone tell me the secret to freezing at the same time, together, simultaneously the first row and first column in an MS Excel Web App spreadsheet. At this time I ...
RHA1705 To freeze both the first row and first column, select cell B2. On the view tab, select "Freeze Panes".
This freezes the rows above and columns towards the left from the active cell.
This solution is no longer accurate. the Freeze Panes menu has changed. Any idea how to do it in the "new and improved" excel web app?
I've tried this and it doesnt work. Is there a new updated trick to use?
It's still the same in Excel for the Web:
- Select the cell below the row(s) you want to freeze and to the right of the column(s) you want to freeze.
- On the View tab of the ribbon, select Freeze Panes > Freeze at Selection.
In the screenshot below, I have selected cell F4, so rows 1 to 3 and columns A to E will be frozen.
