How To Freeze Panes In Excel In South Africa?
The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen.
How To Freeze Panes In Excel In South Africa?
Below is the method for freezing panes in Excel
Excel has a “Freeze panes” for this, in the “View” menu, “Window” item, as you can see from this screenshot:
You select the cell at the right bottom of the area you want to freeze and you do “freeze panes”.
There are some more possibilities you can find while clicking “Help” and searching for “Freeze”.
edit after edit of the original question:
Oh.
Seeing the edit, I think I believe what you want: you want the left columns to be fixed (you can’t scroll down) while you want the other columns to be scrollable.
This is not possible, because it would mean that the number of your row does not correspond with the row number of the cell you’re in.
How do I enable freeze panes in Excel?
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
How do I freeze panes in Excel two ways?
In case you want to freeze more than one column, this is what you need to do:
- Select the column (or the first cell in the column) to the right of the last column you want to lock.
- Go to the View tab, and click Freeze Panes > Freeze Panes.