Format Painter, Freeze Panes & Split Windows

Excel provides powerful tools to improve worksheet formatting and navigation. Format Painter helps copy formatting quickly, while Freeze Panes and Split Windows make large worksheets easier to view and manage.

Format Painter

Format Painter is used to copy the formatting of one cell and apply it to another cell or range of cells.

Uses of Format Painter

• Copy font style, size, and color.
• Copy cell borders and fill colors.
• Copy alignment and number formatting.
• Maintain consistent worksheet design.

Steps to Use Format Painter

1. Select the cell that contains the desired formatting.
2. Go to the Home tab.
3. Click Format Painter.
4. Select the destination cell or range.

Freeze Panes

Freeze Panes keeps selected rows or columns visible while scrolling through large worksheets.

Benefits of Freeze Panes

• Keep headings visible while scrolling.
• View important columns continuously.
• Improve navigation in large datasets.

Freeze Panes Options

Steps to Freeze the Top Row

1. Go to the View tab.
2. Click Freeze Panes.
3. Select Freeze Top Row.

Split Windows

Split Window divides a worksheet into multiple panes, allowing different sections of the same worksheet to be viewed simultaneously.

Benefits of Split Windows

• View different areas of a worksheet at the same time.
• Compare data from different sections.
• Improve navigation in large worksheets.

Steps to Split a Worksheet

1. Select the cell where the split should occur.
2. Go to the View tab.
3. Click Split.

Shortcut Keys