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 ...
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.