How to View Data More Effortlessly by Freezing Panes in Your Excel Worksheet

When there are large data sets in your Excel, you will spend a lot of time on scrolling your worksheet. In this article, we will show you how to freeze panes so that you can view data more effortlessly.

It is needless to say that you will surely view data in an Excel worksheet by scrolling the worksheet. But you could perhaps encounter with such an issue. When you move downwards or move rightwards, you will not be able to see the row header or the column header. If you need to know the headers of a certain cell, you need to scroll back. This can be very troublesome. Thereby, you can follow the steps below and see how to freeze panes.

Freeze Panes

It is a little different for freezing rows or freezing columns. We have divided into several different small parts. We will use this worksheet in the image below as an example.Example

Freeze Top Row

  1. In the worksheet, click the tab “View” in the ribbon.
  2. And then click the button “Freeze Panes” in the toolbar.
  3. After that, you will see a drop-down list. In this step, choose the second option “Freeze Top Row” in the menu.Freeze Top Row

Then you will see a grey line under the first row in the worksheet. When you scroll the worksheet and move downwards, you will find that the top row is always visible.

Top Row

Freeze First Column

In this part, you need to freeze the first column.

  1. Click the button “Freeze Panes” in the toolbar.
  2. And then choose the option “Freeze First Column” in the drop-down list.Freeze First Column

Then you will see a grey line in the left of the first column. When you move rightwards, you can always see the first column in the worksheet.

First Column

Freeze both Top Row and First Column

However, sometimes you need to know both the row header and the column header. You need to freeze both the first row and the first column. You can follow the steps below.

  1. Click the leading cell except for the cell in the first row or column. In this worksheet, we will click the cell B2.
  2. And then click the button “Freeze Pane” in the toolbar.
  3. In the drop-down list, choose the option “Freeze Panes”.Freeze Panes

Next you can see grey lines in the bottom of the first row and the right of the first column. At this time, you can see the first row and column in the worksheet all the time.

Freeze Any of the Panes

There are times that the row headers and the column headers will not be the top row or the first column of a worksheet. Suppose now the range begins at the cell C8. And you need to compare the sales volume of John and Ava.Another Example

Now follow the steps and see how to freeze panes in this condition.

  1. Here you need to click the cell D10 in the worksheet.
  2. And then choose the option “Freeze Panes” under the “Freeze Panes”.

One grey line will be in the top border of the row of the selected cell. This is also the bottom border of the first two rows of the range. And the other grey line will be the left border of the column of the selected cell, which is the right border of the first column of the range. Next you can scroll the worksheet and compare the sales volumes.Result

The next time when you need to freeze any of the panes in the worksheet, you need to select the right cell in the worksheet.

Unfreeze Panes

You need to remember that you cannot use the shortcut keys “Ctrl +Z” on the keyboard to unfreeze panes.

  1. Click the button “Freeze Panes” in the toolbar.
  2. And then choose the option “Unfreeze Panes”.Unfreeze Panes

Thus, you have unfrozen the panes in the worksheet. This is very easy to manipulate.

Take Care of Your Irreplaceable Data

Each time you store some irreplaceable data in Excel documents, you ought to back up them. Therefore, you can make sure that you will not lose the data in Excel data disasters. Yet, if you find that the backed up files are also unavailable, you need to use other techniques. We suggest that you can use our robust Excel recovery tool. This tool can repair corrupted Excel xls files. And you can get back all of your data easily.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair damaged doc and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.