Difference between Freeze Panes and Split Panes of Excel worksheet

Before reading this lesson, please learn below topics by clicking the links.

• Row, Column and Cell in Excel worksheet
• How to Freeze Panes Rows in Excel worksheet
• How to Freeze Panes Columns in Excel worksheet
• How to unfreeze frozen Rows or Columns in Excel worksheet
• How to split panes an Excel worksheet at a Row horizontally
• How to split panes an Excel worksheet at a Column vertically

• In Split Panes, Excel splits its worksheet window vertically along the left-side of selected Column or horizontally along the top-side of selected Row. Freeze Panes just freezes Excel worksheet window vertically along the left-side of selected Column or horizontally along the top-side of selected Row.

• A vertical and/or horizontal Split Pane bar is displayed when you split Excel worksheet window. No bar is displayed when you freeze Excel worksheet window.

• You can adjust the size of Split Panes by clicking, dragging and releasing the mouse pointer over Split Pane bar. You do not have the option to adjust the size of Freeze Panes, except Row height change or Column width change.

• Each of the Split Panes spans the entire worksheet. Freeze panes freezes only a small part of the worksheet, typically top-most Row header or left-most Column header.