Forum Discussion
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...
It's all about active cell. Click in C3 and then go to View | Freeze Panes - select Freeze panes.
Patrick2788Thank you! That did the trick. But now is there a way to lock the bottom totals row.
- 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.