Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What do Freeze Panes do in Excel?

user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/12/09
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Through freeze panes we can customize the view of our Data Sheet in  Excel.

Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Related tutorial: Freeze Panes in Excel2003.

 

When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it's hard to keep track of which column or row of data you are looking at.

To avoid this problem use Excel's freeze panes feature. It "freezes" or locks specific columns or rows of the spreadsheet so that they remain visible at all times.

 

This tutorial covers the freeze panes options in Excel2007 /2010.

 

The steps in this tutorial are:

    1. Freeze the top row

 

    1. Freeze the first column

 

    1. Freeze both columns and rows

 

  1. Unfreeze columns and rows

Jasmin Mathai
by Jasmin Mathai , Executive / Administrative Assistant to Assistant Vice President , United Arab Shipping Co.

Freeze panes freezes (sets) the parts that you would like to see throughout the entire time you scroll  that sheet, either up, down left or right, depending on which cell you chose to freeze the panes.  This is very helpful, if the sheet created is longer than the area displayed on the screen.

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

customize the view of our Data Sheet in  Excel

More Questions Like This