• Excel Video Tutorials

Freeze Panes in Excel 2010


Advertisements

Freezing Panes

If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to the right. MS Excel provides a handy solution to this problem with freezing panes. Freezing panes keeps the headings visible while you’re scrolling through the worksheet.

Using Freeze Panes

Follow the steps mentioned below to freeze panes.

  • Select the First row or First Column or the row Below, which you want to freeze, or Column right to area, which you want to freeze.

  • Choose View Tab » Freeze Panes.

  • Select the suitable option −

    • Freeze Panes − To freeze area of cells.

    • Freeze Top Row − To freeze first row of worksheet.

    • Freeze First Column − To freeze first Column of worksheet.

Freeze Panes Use
  • If you have selected Freeze top row you can see the first row appears at the top, after scrolling also. See the below screen-shot.

First Row Freezed

Unfreeze Panes

To unfreeze Panes, choose View Tab » Unfreeze Panes.

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements