Force Byte - Freezing panes in Excel sheet
After you have split a worksheet window into panes, you can freeze the left panes, the top panes, or both by choosing the "Freeze Panes" command from the "Window" menu.
For example, if the window is split vertically, the command keeps hold of the columns that are in view in the left pane so that you can scroll through the worksheet without losing sight of these columns. Similarly, if the window is split horizontally, it keeps hold of the rows that are in view in the top pane so that you can scroll through the worksheet without losing sight of these rows.
Moreover, if you split the window both vertically and horizontally, both the "columns" in the left panes and the "rows" in the top panes are frozen after choosing the command. In other words, you cannot scroll the upper left pane in any direction. In addition, you can scroll only the columns in the upper right pane and only the rows in the lower-left pane. Furthermore, you can scroll the lower right pane in either direction. (See Figure 1 below.)
After the use of "Freeze Panes" command, it will be replaced by the "Unfreeze Panes" command on the "Window" menu. Then you can simply choose this command to unfreeze the panes so that you can scroll all of them again.
Actually, you can split and freeze panes simultaneously by choosing the "Freeze Panes" command directly, without first splitting the sheet window into panes. After selecting a cell and choosing the command, the window splits, and the panes above and to the left of the active cell become static. When you use this method, subsequently choosing "Unfreeze Panes" command they both unfreeze and remove the panes.
In the next issue, I will talk about another new topic on our Office software suite.
"Sharing IT as it applies to your daily life"
Figure 1