Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Add Freeze Panes In MS Excel 2010

When a user adds rows or column headings in the worksheet, it is not visible while scrolling up and down the worksheet. MS Excel offers a smart solution for this with freezing panes. Freezing panes simply helps in keeping the heading visible while scrolling through the worksheet.

Using Freeze Panes

  • Select the first row or column or row Below which you like to freeze. Users can even select the Column right to area that they want to freeze.
  • Choose View tab followed by Freeze Panes.
  • Then select from the variety of suitable option:
    • Freeze Panels – It freezes the area of cells.
    • Freeze Top Row – It freezes the first row of worksheet.
    • Freeze First Column – It freezes the first Column of worksheet.

MS Excel Tutorial

If you select the Freeze top, then you find that first row appears at the top while scrolling, like this.

MS Excel Tutorial

Unfreeze Panes

In order to unfreeze Panes, simply choose View Tab and click on Unfreeze Panes.

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow