How to Add a Header in Excel: Column Headers, Print Headers, and Table Headers Done Right

How to Add a Header in Excel Without Confusing Three Different Header Things

Search the web for how to add a header in Excel and you'll get three completely different answers, all of which are correct, and none of which solve the problem you actually had. That's because Excel uses the word header to mean three separate things — and the right method depends on which one you need.

The page header that appears at the top of every printed sheet. The column header row at the top of your data. And the Table header that Excel attaches when you convert a range into a structured Table. Three concepts. Three menus. Three keyboard shortcuts. Pick the wrong one and you'll end up with the right text in the wrong place.

The short version. To add a print header — something that shows up at the top of every printed page like a company name, date, or page number — go to Insert → Header & Footer, or switch to Page Layout view and click the header area at the top of the sheet. To add a column header row above your data, you just type labels in row 1 and freeze that row with View → Freeze Top Row. And to add a Table header — which gives you sortable, filterable, auto-styled headers — select your range and press Ctrl+T.

This guide walks through every header type, the menus involved, the AutoFill codes you can drop into headers (page numbers, dates, file paths), and the option you really want when you ask how to repeat header row in Excel across printed pages. By the end, you'll know exactly which kind of header you need and where to find the button. If you want broader practice across Excel features, our Excel hub page indexes every formula and feature tutorial we publish.

One quick orientation before we dig in. The menus and screenshots below are written for Excel 365 and Excel 2021 on Windows. Mac users get essentially the same options but the ribbon layout differs slightly and a few keyboard shortcuts change (Cmd in place of Ctrl, mostly). We'll flag the meaningful differences as we go.

Adding a Page Header (the One That Prints on Every Sheet)

When most people ask how to add a header in Excel, what they actually want is a page header — the text that shows up at the top of every printed page. Company name on the left. Quarterly Financial Report centered. Page number on the right. Standard report stuff. It does not appear in the normal worksheet view, which is exactly why people get confused. You don't see it until you switch views or hit Print Preview.

The fastest way. Click Insert on the ribbon, then click Header & Footer in the Text group on the right. Excel switches the worksheet into Page Layout view and drops your cursor into the center section of the header area. Just start typing. Three sections sit side by side — left, center, right — and you can put different text in each. Click the section you want and type, or use Tab to jump between them.

The other fastest way. Click the Page Layout tab, then click the small dialog launcher in the bottom-right corner of the Page Setup group. The Page Setup dialog opens. Click the Header/Footer tab. From here you can pick a built-in header from the dropdown — things like Page 1 of ?, Confidential, [filename], Page 1, or Prepared by [Author] — or click Custom Header to build your own. The custom dialog has the same three left-center-right sections plus a row of toolbar buttons that insert AutoFill codes. We'll explain those in a second.

The visual way. Click the View tab and switch to Page Layout view (the middle button in the Workbook Views group). The worksheet redraws to look like a printed page, complete with a visible header strip at the top and footer at the bottom. Click the header area and type. This is by far the most intuitive method because you can see what you're doing, and it's the way I'd recommend if you're new to Excel headers.

To get back to normal view when you're done, click View → Normal. The header text doesn't display in normal view — it only appears in Page Layout view and on printed pages — but it's saved with the workbook and will print every time.

Adding a Column Header Row (the One That Labels Your Data)

The second meaning of header in Excel is the column header row — the labels in row 1 that name each column of your data. Name, Address, Phone, Order Total. That kind of thing. Strictly speaking, Excel doesn't have a separate feature for this. You just type the labels in row 1. The work isn't in adding them; it's in keeping them visible when you scroll down, and making them behave correctly when you sort, filter, or print.

Step 1 — Type the labels. Click A1 and type the first column label. Tab to B1, type the next one, and so on across the row. Standard stuff. To make the header row stand out visually, select row 1 by clicking the row number on the left, then apply bold (Ctrl+B), a fill color from the Home tab, and maybe a bottom border from the Borders dropdown.

Most analysts use a dark fill with white text for readability. Excel's built-in cell styles (Home tab → Styles dropdown) include a Heading style that does all of this in one click if you don't want to fiddle with formatting.

Step 2 — Freeze the header row. This is the bit most people miss. Click View → Freeze Panes → Freeze Top Row. From now on, when you scroll down through your data, row 1 stays pinned at the top of the screen so you can always see which column is which. It's a quality-of-life fix that takes two seconds and makes any spreadsheet over 30 rows infinitely easier to work with.

Variation — freeze more than the top row. Sometimes you have a header that spans two rows (a title in row 1, column labels in row 2). Click into A3 (the first cell below the rows you want to freeze), then choose View → Freeze Panes → Freeze Panes. Excel freezes everything above and to the left of your selection. To freeze the first column at the same time, click B3 first, then Freeze Panes.

To unfreeze: View → Freeze Panes → Unfreeze Panes. Same menu, different label depending on the current state.

One thing worth knowing. Freezing panes affects what you see on screen, not what prints. To make a header row repeat at the top of every printed page, you need Print Titles, which we cover further down. Easy mistake to make — and easy to fix.

Adding Table Headers (the Sortable, Filterable Kind)

The third meaning of header in Excel is the one most beginners haven't met yet but power users use constantly. When you convert a range into a Table, Excel attaches structured headers to your data that come with sort dropdowns, filter buttons, auto-extending formatting, and structured references in formulas. It's the modern way to manage any tabular data and it solves about half the problems people run into with raw ranges.

How to put a header on Excel via the Table feature. Click anywhere inside your data range. Press Ctrl+T, or go to Insert → Table. A dialog appears asking you to confirm the range and whether your data has headers. Make sure the My table has headers checkbox is ticked if your row 1 already contains labels, then click OK. Excel converts the range into a Table, applies a default style (alternating row colors), adds filter dropdowns to each header, and gives the Table a name (Table1, Table2, etc.) you can rename in the Table Design tab.

From that point on, the header row is structurally part of the Table rather than just typed text in row 1. Two practical benefits flow from that.

One — headers stay visible without freeze panes. When you scroll down through a Table, Excel automatically replaces the column letters at the top of the worksheet (A, B, C) with your Table headers (Name, Address, Phone). No need to freeze the top row — it's built in for any cell currently inside the Table.

Two — formulas can use structured references. Instead of writing =SUM(B2:B100), you can write =SUM(Table1[Order Total]). Way more readable, and the formula automatically expands when you add new rows. If you ever wondered why spreadsheets in finance teams look so much cleaner than the ones built by occasional users, this is one of the reasons. Structured references essentially eliminate the off-by-one errors that come from manually tracking ranges.

To turn the Table back into a plain range — keeping the values and formatting but losing the structural features — click anywhere in the Table, go to the Table Design tab, and click Convert to Range. The header row stays where it is, just as typed text in row 1, without the filter buttons or structured references.

How to Repeat a Header Row on Every Printed Page

This is the question that lands on so many help-desk tickets that it deserves its own section. I print a multi-page report and only the first page has my column headers. How do I make them repeat? The answer is Print Titles, and it's hidden in a menu that most people never click on.

Open the workbook. Click the Page Layout tab on the ribbon. Look for the Print Titles button — it sits in the Page Setup group, usually about halfway across the tab. Click it. The Page Setup dialog opens with the Sheet tab already active.

You're looking at the Rows to repeat at top field. Click inside it. Then click the small range-picker icon on the right (a tiny spreadsheet with a red arrow). The dialog collapses out of the way, and you can click directly on the row number in your worksheet — click 1 on the left edge to select all of row 1, or click and drag across rows 1 and 2 if your header spans two rows. The field fills in with something like $1:$1 or $1:$2. Click the range-picker icon again to bring the dialog back, then click OK.

Press Ctrl+P to preview. Page through the printout and you'll see your column headers at the top of every page. Save the workbook. The Print Titles setting sticks with the file from now on — anyone who opens and prints it will get the repeated header automatically.

Two related questions come up. How do I repeat a column at the left edge? Same dialog, Columns to repeat at left field. Click the range picker, click the column letter, click OK. Useful if you have a wide table where row labels (like product names or account numbers) print on the leftmost column and you want them visible on every horizontal page.

What if Print Titles is greyed out? You're probably editing a header or footer at the moment. Click into a cell in the worksheet first, then try again. It's a quirk in the way Excel enables and disables the dialog.

Putting a Logo or Picture in a Header

One detail that crops up in business reports: inserting a company logo into the page header so it prints on every sheet. Excel supports this natively, and once you've done it the logo travels with the workbook automatically.

How to add an image to an Excel header. Switch to Page Layout view (View → Page Layout). Click the header section where you want the logo — left, center, or right. The Header & Footer Tools tab appears on the ribbon. Click Picture in the Header & Footer Elements group. A file picker opens. Choose your logo file (PNG, JPG, or any standard format) and click Insert.

The header section now displays &[Picture] as a placeholder. Click outside the header to commit it, and the actual logo appears. If it's too big — which it usually is — click back into the header section, click the picture once to select it, and then click Format Picture on the Header & Footer Tools tab. The Format Picture dialog lets you scale the image down to a sensible size (typically 30–50% of the original works for letterhead-style logos) and crop it if needed.

Common pain point. If the logo prints way too large, the source file is too high-resolution. Resize the actual image file to about 200 pixels wide before inserting it into the header. Excel will scale anything you give it, but a smaller source produces a sharper printed result and a smaller workbook file. Save the image as PNG with transparent background if you don't want a white rectangle behind your logo.

You can mix pictures and text in the same header section, though it gets fiddly. The more common pattern is a logo on the left, title text in the center, page numbering on the right — using all three sections rather than cramming everything into one.

Headers, Accessibility, and Why It Matters

A column header row in Excel isn't just a label for human readers. Screen readers and accessibility tools rely on it to announce data correctly. If your spreadsheet might ever be opened by a colleague using a screen reader, or sent to a regulator who runs accessibility checks, the way you set up headers matters more than the visual styling.

The single most important step is converting your data range into a Table (Ctrl+T) with the My table has headers checkbox ticked. That tells Excel — and assistive technology — that row 1 is structurally a header, not just typed text in cells. When a screen reader navigates a Table, it announces the column name before each value: Name: John Smith. Phone: 555-1234. Without the Table structure, the reader just says John Smith, 555-1234 with no context.

The same logic applies to PivotTables — they inherit header semantics from the source data, so a properly headered source produces an accessible pivot. And when you export to PDF (File → Export → Create PDF/XPS), Excel preserves the Table headers as tagged structure in the PDF, which is what accessibility scanners look for.

Beyond Tables. If your column headers contain abbreviations or acronyms (Qty, YOY, GMV), consider expanding them in a comment or cell note so the meaning is clear to first-time readers. Excel has an Accessibility Checker (File → Info → Check for Issues → Check Accessibility) that flags any Table without descriptive headers and other structural problems.

For training and broader spreadsheet skills beyond headers, our Microsoft Excel practice test covers headers, formulas, formatting, charts, and the everyday tasks that come up in admin and analyst roles.

Which Header Should You Add?

Here's the practical decision tree we promised. If you're printing a multi-page report and you want the company name, page numbers, or date at the top of every page, you want a page header. Insert → Header & Footer. Done.

If you're building a spreadsheet with tabular data — names, transactions, line items, whatever — and you want to label each column, you want a column header row. Type the labels in row 1, format them, and freeze the row with View → Freeze Top Row.

If you're working with data you'll sort, filter, or extend over time, upgrade the column header row to a full Table. Ctrl+T. You get the same headers plus filter dropdowns, structured references, and automatic row-color banding. Costs nothing to set up and pays off every time you interact with the data.

If you're printing tabular data that runs over multiple pages, also set Print Titles in Page Layout so the column header row repeats on every page. This is the one most people miss until a colleague complains they can't tell which column is which on page 4.

If you're publishing a report externally or to a regulator, convert the data to a Table for accessibility, set the Print Titles, and add a proper page header with the document title and page numbers. The combination produces a printout that's clear to read, easy to navigate, and compliant with most accessibility standards.

And if you find yourself wanting a header that's visually merged across multiple cells — say, a big Quarterly Report title across columns A through F — resist the urge to use Merge & Center. Use Format Cells → Alignment → Center Across Selection instead. It centers text across cells without merging them, which keeps your data tools (sorting, pivots, structured references) working correctly. Visual merging breaks a surprising number of things in Excel.

Once you've got your headers sorted, related skills include how to sort data in Excel, freezing additional panes for wide spreadsheets, and adding footers with the same Header & Footer dialog. Footers use identical AutoFill codes and live in the same Page Setup tab — once you understand headers, footers are five minutes of additional work.

The Bottom Line on Adding Headers in Excel

The phrase add a header in Excel covers three separate features, and the right one depends entirely on what you're trying to achieve. If the goal is to print page numbers and a title at the top of every sheet, you want a page header — Insert → Header & Footer.

If the goal is to label the columns in your data, you want a column header row — type labels in row 1, freeze the row, and convert to a Table for the full feature set. If the goal is to repeat those column labels on every printed page of a multi-page report, that's Print Titles — Page Layout → Print Titles → Rows to repeat at top.

The features are independent and stackable. A polished business report typically uses all three: a page header for branding and pagination, a column header row in row 1 to label data, and Print Titles to repeat that header row across every printed page. Set them up once when you build the workbook and they travel with the file forever.

The single biggest mistake to avoid is conflating page header with column header. The page header sits above the data grid and prints on every page. The column header row sits inside row 1 and labels your data. They're not the same thing, they live in different menus, and using one when you needed the other produces a printout that looks wrong and is frustrating to debug. Once you know which is which, picking the right menu is instant — and your printouts start looking like the polished reports they should be.