Excel shortcuts

How to Freeze Panes in Excel: The Ultimate Guide

If you work with large spreadsheets in Microsoft Excel, you may find it helpful to keep certain rows or columns visible while you scroll through the rest of the sheet. This is called "freezing" panes. Freezing panes can be especially helpful if your sheet contains column headers (titles) or if you need to see which row you're working on while scrolling through a large sheet. In this article, we'll show you how to freeze panes in Excel so you can keep your place while scrolling.

Before we get started, it's important to note that you can only freeze panes in an Excel worksheet, not in a workbook (a collection of worksheets).

How to Freeze Panes in Excel

There are two ways to freeze panes in Excel:

  • You can freeze panes so that certain rows or columns are always visible when you scroll.
  • You can also use split panes to divide your worksheet into separate areas that you can scroll independently.

Let's take a look at how to freeze panes in Excel.

How to Freeze Rows or Columns in Excel

To freeze rows or columns so that they're always visible when you scroll, follow these steps:

  1. Open the worksheet that you want to freeze panes in.
  2. Select the cell below the row(s) that you want to keep visible when you scroll down, or to the right of the column(s) that you want to keep visible when you scroll to the right. For example, if you want to freeze the top row of your worksheet, select cell A2.
  3. On the View tab, in the Window group, click Freeze Panes.
  4. Click Freeze Panes.

Now when you scroll down, the top row will remain visible. And when you scroll to the right, the left column will remain visible.

How to Use Split Panes to Freeze Rows and Columns in Excel

If you want to keep multiple rows or columns visible as you scroll, you can use the split panes feature instead of freezing panes. To split panes in Excel, follow these steps:

  1. Open the worksheet that you want to split.
  2. Select the cell where you want to split the worksheet. For example, if you want to split the worksheet at row 10, select cell A10.
  3. On the View tab, in the Window group, click Split.
  4. In the Split box, enter the number of rows that you want to display in the top pane. For example, if you want to display the first 10 rows in the top pane, enter 10.
  5. Click OK.

Now you can scroll through each pane of your worksheet independently. To remove split panes, follow these steps:

  1. On the View tab, in the Window group, click Split.
  2. Click Remove Split.

Tips for Using Freeze Panes and Split Panes in Excel

Now that you know how to freeze panes and split panes in Excel, here are a few tips to keep in mind:

  • You can only have one set of frozen panes or split panes per worksheet. If you try to freeze or split panes again, Excel will remove the existing freeze or split.
  • If you scroll to the bottom of your worksheet and the row headers (the numbers on the left side of the sheet) disappear, it means you've scrolled too far and the panes are no longer frozen. To fix this, scroll back up until the row headers reappear, and then try scrolling down again.
  • If you scroll to the right of your worksheet and the column headers (the letters at the top of the sheet) disappear, it means you've scrolled too far and the panes are no longer frozen. To fix this, scroll back to the left until the column headers reappear, and then try scrolling to the right again.
  • If you have a lot of data in your worksheet, you may want to consider using an Excel table instead. Tables have built-in features that make it easy to scroll through large amounts of data, and they also support features like filtering and sorting.

Conclusion

We hope this article has helped you learn how to freeze panes and split panes in Excel. If you have any questions or comments, please let us know in the comments section below. And be sure to check out our other Excel articles for more tips and tricks.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.