Freeze panes & Split in Excel

A frequenlty used formatting in spreadsheets.

Freeze Panes is used when you have multiple rows/columns of data that could not be fully viewed in a full size window. It allows you to freeze/fix certain columns and/or rows, so when you scroll down or right the frozen columns and/or rows will still stay in its current position in the windows.

Freezing Panes:

1. Window>Free Panes

Some examples:

1. Action: Click on column B, and freeze panes
Outcome: Column A will keep staying at the left of the window if scrolling right

2. Action: Click on row 2, and freeze panes
Outcome: Row 1 will keep staying at the top of the window if scrolling down

3. Action: Click cell B2, and freeze panes
Outcome: Row 1 will always stay at top and column A will always stay at left
Split is another function in manipulating the window size. Click on a cell and split window will result in a window being split into 4 different windows with identical content. In this case, you will have 4 windows allowing you to scroll up/down and left/right on each of the split window.

Creating Split:

1. Window>Split