- Computers & Software
How to freeze a range of cells in Microsoft Excel?
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.
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.
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
The freeze option works only with either a row or a column and cannot be applied both simultaneously.