ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software

How to freeze a range of cells in Microsoft Excel?

Updated on February 15, 2013

While working on a long worksheet with many data in it. While scrawling through the spreadsheet you might get confused with the values of different cells as the headlines stays above. Then you might have to go up and confirm what the data of the columns mean. This hassle can be easily avoided by freezing our Top Row or Left Most Column. Doing so, you will be able to see the headline or name of all the fields required. In this tutorial we will be learning the process to freeze particular row or column with headline.

Get yourself ready

To do the process, we have to use a computer which has Microsoft Excel installed in it. Moreover, we are showing the tutorial using Microsoft Excel 2010.

Steps to Freeze a range of cells in Microsoft Excel

Step 1: Select the exact next range of the cells of the Particular Range of cell you want to keep as freeze in the worksheet.

Step 2: Click on the View Tab of the Excel Ribbon to open its toolbar.

Select the range and click on View tab
Select the range and click on View tab

Step 3: From the View Toolbar’s Window portion, select the Freeze Panes Option.

Step 4: Now Select the Freeze Pane option from the menu appeared.

Freeze the selected row throw Freeze Panes option
Freeze the selected row throw Freeze Panes option

How the process works

As we select the Freeze Panes option from view toolbar, we are enabling the software to keep the specific row and all the rows above or left of it to be constantly visible while we are scrawling, watching or typing something beyond the initial range of cell appearance of the particular worksheet

Think more

The freeze option works only with either a row or a column and cannot be applied both simultaneously.


    0 of 8192 characters used
    Post Comment

    No comments yet.