How to Freeze Rows in Excel - The Step by Step Guide to Freezing Panes

October 15, 2018

This Excel tutorial will teach you how to freeze rows in Excel. You will also learn how to freeze columns in Excel. Freezing rows and columns is the ability to keep an area of the worksheet visible while you scroll around the worksheet. It is very useful when you have a large data set with thousands of rows and or lots of columns.

 

Here is how to freeze rows in Excel:

 

Method 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In this example I have a list of sales people with their sales figures.

 

 

 

 

 

 

 

 

 

 

 

 

 

If I scroll down I can’t see the column headings. I need to freeze the column headings in the first row so that when I scroll down I can still see the column headings.

 

As I want to lock the first row the entire second row must be selected. Click on the View tab in the ribbon and in the Window group click on the Freeze Panes command button which will open a drop down menu. From this drop down menu select Freeze Panes.

Once Freeze Panes has been enabled you will notice a dark line where the row has been locked.

 

 

 

 

 

 

 

 

 

 

 

 

 

Now when you scroll down the column headers are still visible.

 

 

Method 2

 

Again click on the View tab in the ribbon and in the Window group click on the Freeze Panes command button which will bring up a drop down menu. This time Select Freeze Top Row from the drop down menu.

 

This will only work if your column headers are in the top row.

 

 

How to Freeze Columns in Excel

 

Freezing columns is very much like freezing rows but instead columns are locked.

In this example I again have a list of sales people along with their sales but this time across columns instead of rows. I want column A locked.

 

The quickest way to lock column A is by clicking on the View tab in the ribbon and then the Freeze Panes command button from the Window group. This will bring up the drop down menu. Select Freeze First Column from the drop down menu.

 

Now when I scroll across to the right the first column is still showing.

 

This only works if you want to freeze the first column. If you want to freeze another column then you select the entire column after the column you want to freeze. For example, if you want column C locked then you select column D and instead of selecting Freeze First Column from the menu select Freeze Panes.

 

 

How to Unfreeze Panes

 

To unfreeze rows or columns you follow the same procedure as when you freeze rows or columns but click on the Unfreeze Panes button from the drop down menu.

 

 

 

Other View Options in Excel?

 

If freezing panes is still not doing the trick, maybe because your workbook contains lots of data and it is difficult to compare different sections, then there are two other ways to view information in your worksheet:

 

1) Open a new window

 

2) Split a worksheet

 

 

Opening a New Window

 

Opening a new window means you can view the same workbook but in different windows.

 

To open a new window click on the View tab in the ribbon and in the Window group click on the New Window command button.

 

A new window opens up. You can now easily compare different sections of the same workbook.

 

 

Splitting a Worksheet

 

Sometimes you don’t want a separate window to compare different sections of the worksheet. You can instead split a worksheet which means the worksheet will be split into multiple panes and each pane can be individually scrolled.

 

Select the cell where you want to split the worksheet. In this example I have selected cell I17.

 

Click on the View tab in the ribbon and in the Window group click on the Split command button.

 

The worksheet is now split into four panes. You can scroll each pane individually using the scroll bars at the bottom.

 

Once you have created the split you can move the horizontal and vertical dividers by clicking and dragging them.

 

To remove the split you just click on the Split button again.

 

I hope you have enjoyed the tutorial on how to freeze rows and columns. If you have any questions or feedback then please leave a comment below. I would love to hear from you.

 

Please reload

Our Recent Posts

Please reload

Archive

Please reload

Tags

Please reload

  • Facebook Social Icon
  • Pinterest Social Icon
  • LinkedIn Social Icon
  • Google+ Social Icon
  • Twitter Social Icon

Excel Master Consultant

©2018 by Excel Master Consultant

This site was designed with the
.com
website builder. Create your website today.
Start Now