how to freeze first two rows in excel 2010

On the drop-down menu, select the ‘freeze panes' optionĬlick on the ‘unfreeze panes' option from the list Consider taking the following steps to unfreeze Excel rows: By doing this, you eliminate the frozen marks from your page. If you finish working with your frozen rows, you may want to unfreeze them. Related: Aptitude test: definition, types and tips Unfreezing Excel rows

Open your Excel sheet and go to the ‘view' tab at the top of your screen.įrom the drop-down menu, select ‘freeze panes'. To freeze the top Excel row, take the following steps: It can be challenging to freeze a random row without first locking all the rows above it. Note that you freeze all the rows from the top of your spreadsheet to the row you want to freeze when you freeze multiple rows.

To freeze the rows, select the 'view' tab under the Excel menu and then click 'freeze panes' from the drop-down menu. Related: What are Excel IF statements? (With examples and functions) 2. Once you do, select the rows below the set of rows you want to freeze and move to the next step. The first step is to identify Excel rows that you want to freeze. Identify the rows to freezeĭepending on the row you want to use, you can choose to freeze the top row or a set of rows. Here are a few steps on how to freeze an Excel row: 1. In this article, we explain how to freeze Excel rows, discuss how to unfreeze them, explain the difference between freezing and locking in Excel, explore the benefits of freezing them and discuss alternative ways to view your rows.

Learning how to freeze Excel rows can help leave some of the rows visible at all times, allowing you to navigate your spreadsheet easily. It can also help you present large sets of data, but, keeping track of everything can be challenging. Excel is a program that allows you to create spreadsheets to organise, compare, analyse and interpret data.

How to freeze first two rows in excel 2010