Forum Discussion
DesireeLueloff
Mar 03, 2023Copper Contributor
Cannot lock multiple rows & columns
I am working on a spreadsheet to track my team sales and I would like to lock the top 2 rows and first 2 colums but it seems I can only freeze one or the other the way I am going about it. If po...
DesireeLueloff
Mar 03, 2023Copper Contributor
Patrick2788Thank you! That did the trick. But now is there a way to lock the bottom totals row.
Patrick2788
Mar 03, 2023Silver Contributor
Unfortunately, not with Freeze Panes which freezes anything above or to the left of the active cell. You could use View | New Window and pop open a second view of the sheet and leave it at the totals row.