How to Insert a Header Row in Excel: A Step-by-Step Guide

PDF download Download Article
Add columns or row headers to your Excel spreadsheet
PDF download Download Article

There are several ways that you can create headers in Excel, and they all serve slightly different purposes. You can freeze a row so that it always appears on the screen, even if the reader scrolls down the page. If you want the same header to appear across multiple pages, you can set specific rows and columns to print on each page. If your data is organized into a table, you can use headers to help filter the data. Here's how to add a header row in Excel using your Windows or Mac computer.

Insert a Header in Excel

To turn on Excel table headers, click the table and click the Table Design or Table tab at the top. In the Table Style Options section, check the box for Header Row .

Method 1
Method 1 of 5:

Showing the Header Row

PDF download Download Article
  1. 1
    Click anywhere on the table. If you want to turn Excel table headers on and off, you can do so from the toolbar. When you click on the table, you should see a new tab pop up in the ribbon. [1]
  2. 2
    Click Table Design . This is in the top toolbar.
    • On Mac, you'll need to click Table .
    Advertisement
  3. 3
    Check the box for "Header Row". This is in the Table Style Options group.
    • This will enable headers for your tables if they were previously hidden.
    • To hide headers, uncheck the Header Row box.
    4. Advertisement
Method 2
Method 2 of 5:

Freezing the Header Row

PDF download Download Article
  1. You can set Excel to freeze your header row so it's always visible, even as you scroll. [2]
    • If your header row is in row 1, you don't have to click any cells. Just continue to the next step.
    • If your header row is down further, such as in row 2 or 3, click a cell below the header row.
      • For example, if the row that contains your column labels is row 5, you will need to click a cell in row 6.
  2. You'll see it at the top of the window. [3]
  3. This menu is in the toolbar at the top of Excel. A list of freezing options will appear. [4]
  4. The option you select on this menu depends on whether your header row is in row 1 or in a different row: [5]
    • If your header row is in row 1 (the first row on your sheet), select Freeze Top Row . This ensures that the top row of your sheet remains locked into position, even as you scroll through your data.
    • If your header row is in a different row, such as row 3, select Freeze Panes . This freezes the row above the cell you selected in Step 1.
      • For example, if you selected A6 in Step 1, selecting Freeze Panes will freeze row 5, making it your header row. This row will always stay visible as you scroll through your data.
    • The Freeze Panes option works as a toggle. That is, if you already have panes frozen, clicking the option again will unfreeze your current setup. Clicking it a second time will refreeze the panes in the new position.
  5. Create a visual contrast for this row by centering the text in these cells, applying bold text, adding a background color, or drawing a border under the cells. This can help the reader take notice of the header when reading the data on the sheet.
    6. Advertisement
Method 3
Method 3 of 5:

Printing a Header Row Across Multiple Pages

PDF download Download Article
  1. If you have a large worksheet that spans multiple pages that you need to print, you can set a row or rows to print at the top of every page. [6]
  2. You'll find this in the Page Setup section. [7]
  3. Click the button next to the Print Area field and then drag the selection over the data you want to print. Don't include the column headers or row labels in this selection.
  4. This will allow you to select the row(s) that you want to treat as the constant header. [8]
  5. The rows that you select will appear at the top of every printed page. This is great for keeping large spreadsheets readable across multiple pages.
  6. This will allow you to select columns that you want to keep constant on each page. These columns will act like the rows you selected in the previous step, and will appear on every printed page. [9]
  7. You can include the company title or document title at the top, and insert page numbers at the bottom. This will help the reader get the pages organized. To set the header and footer:
    • Click the Header/Footer tab
    • Click the Header or Footer drop down menus to select a preset header.
    • Alternatively, click Custom Header or Custom Footer to create your own.
  8. . You can send the spreadsheet to print now, and Excel will print the data that you set with the constant header and columns you chose in the Print Titles window.
    • Click Print to start the printing process.
    • Check the print preview in the preview section.
    • Click Print (the printer icon) to print the spreadsheet.
    9. Advertisement
Method 4
Method 4 of 5:

Creating a Header in a Table

PDF download Download Article
  1. When you convert your data to a table, you can use the table to manipulate the data. One of the features of a table is the ability to set headers for the columns. Note that these are not the same as worksheet column headings or printed headers.
  2. Confirm that your selection is correct.
  3. This will create a table from the selected data. The first row of your selection will automatically be converted into column headers.
    • If you don't select "My table has headers," a header row will be created using default names. You can edit these names by selecting the cell.
  4. This will show or hide the header. It won’t delete the header information, so you can turn it on and off as needed. [10]
    • Click the table.
    • Click the Table Design or Table tab.
    • Check or uncheck the "Header Row" box to toggle the header row on and off. You can find this option in the Table Style Options section.
    • Note that turning the header off will also remove any applied filters from the table.
    5. Advertisement
Method 5
Method 5 of 5:

Add and Rename Headers in Power Query

PDF download Download Article
  1. This will cause the “Table Design” and “Query” tabs to appear at the top of Excel. This method is used to add row headers to the dataset you imported using Get & Transform (Power Query). You’ll also be able to rename existing headers using this method. [11]
    • Note that this method requires the first row of your dataset to contain column header names.
  2. This is in the top toolbar.
  3. You can find this in the Get & Transform Data section. The Power Query Editor window will open.
  4. This is a tab at the top of the Power Query Editor.
  5. To do so:
    • Click Use First Row as Headers .
    • Select Use First Row as Headers in the drop down menu. This will make row 1 into the headers for the table.
  6. In the Power Query Editor, you can rename the column headers using these steps:
    • Double-click the column header name.
    • Type in a new name for the header.
    • Press ↵ Enter to confirm the name.
  7. This will reload the imported table with the changes you made in the editor.
    8. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I get my headers to change the dates and days automatically?
    Community Answer
    Use the function @Today. You'll find it near the top under the choice "Functions".
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 7
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Apply Conditional Formatting in Excel
      5 Easy Steps to Unmerge Cells in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Sort a List in Microsoft Excel
      How to
      Use the Sum Function in Microsoft Excel
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      The Best Ways to Make & Format Lists in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/turn-excel-table-headers-on-or-off-c91d1742-312c-4480-820f-cf4b534c8b3b
      2. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      3. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      4. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      5. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      6. ↑ https://support.microsoft.com/en-us/office/print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c
      7. ↑ https://support.microsoft.com/en-us/office/print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c
      8. ↑ https://support.microsoft.com/en-us/office/print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c
      9. ↑ https://support.microsoft.com/en-us/office/print-rows-with-column-headers-on-top-of-every-page-d3550133-f6a1-4c72-ad70-5309a2e8fe8c
      1. ↑ https://support.microsoft.com/en-us/office/turn-excel-table-headers-on-or-off-c91d1742-312c-4480-820f-cf4b534c8b3b
      2. ↑ https://support.microsoft.com/en-us/office/set-up-your-header-row-a0945ce6-0b35-45e2-bda1-e9f0d9806404

      About This Article

      Article Summary X

      1. Click the View tab.
      2. Select the corner cell under the header row.
      3. Click Freeze Panes .
      4. Apply formatting to the header row.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,126,120 times.

      Reader Success Stories

      • Antoine Hajjar

        Aug 14, 2016

        "It was a good and fast help, backed up with pictures. I liked that. I needed to know about lines as header. Thank ..." more
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement