Easily Freeze Row and Column Titles in Excel

by Avantix Learning Team | Updated February 21, 2022

Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows)

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one. This does not affect the cells that will print. The column headings or titles can be one row or multiple rows at the top of the worksheet. The row headings (which appear on the left) can be one or more columns on the left of the data.

Freezing row and / or column headings

To freeze row and / or column headings:

  1. Scroll down until the top row or rows that you want to freeze are displayed at the top of the worksheet.
  2. Scroll to the right until the left column or columns that you want to freeze are displayed on the left of  the worksheet.
  3. Click below the row you want to freeze and to the right of the column you want to freeze. For example, if you want to freeze row 6 and column A, click in B7. If you want to freeze row 2 but do not want to freeze any columns, click in A3.
  4. Click the View tab in the Ribbon and then click Freeze Panes.
  5. In the drop-down menu, select Freeze Panes. The column and row headings will now be locked into place.

Below is the Freeze Panes drop-down menu:

Freeze panes menu on the View tab in the Ribbon in Microsoft Excel.

In the sample below, we wanted to freeze row 1 and no columns, so we clicked in A2 and then chose Freeze Panes:

Sample worksheet to freeze titles in Excel.

Unfreezing row and / or column headings

To unfreeze row and / or column headings:

  1. Click anywhere in the worksheet.
  2. Click the View tab in the Ribbon and then click Freeze Panes.
  3. In the drop-down menu, select Unfreeze Panes.

Freezing column headings by creating a table

If you change a data set or list into a table, Excel will automatically freeze the header row (column headings) so that when you scroll down, the header row will always be locked in place at the top of the table.

To create a table:

  1. Click in the data set or list.
  2. Click the Insert tab in the Ribbon and then click Table in the Tables group
  3. If the selected range contains data that you want to display as table headers, select the My table has headers check box. Table headers display default names if you do not select the My table has headers check box. Ideally, your table should always have headers.
  4. Click OK.

Below is the Create Table dialog box:

Create table dialog box in Microsoft Excel.

When you scroll down in the table, the column headings should be locked at the top of the table automatically.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

More Resources

10 Great Excel Keyboard Shortcuts for Filtering Data

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

How to Highlight Errors, Blanks and Duplicates in Excel Worksheets

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

How to Replace Blank Cells with a Value from the Cell Above in Excel

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to Visual Basic for Applications (VBA)

VIEW MORE COURSES >

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2022 Avantix® Learning

You may also like

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Summary
How to Freeze Row and Column Headings in Excel Worksheets
Article Name
How to Freeze Row and Column Headings in Excel Worksheets
Description
As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one. This does not affect the cells that will print.
Author
Publisher Name
Avantix Learning

Pin It on Pinterest

Share This