In Excel, a text header usually means text printed at the top of each page, such as a report title or date; add one in the desktop app with Insert > Text > Header & Footer, then click a header area and type. If you mean labels at the top of worksheet columns, put them in cells in a header row instead: those labels are part of the data grid and behave differently from print headers.
What “Excel text header” can mean
Excel uses similar language for two separate features, which is why searches for a “text header” can be confusing. A page header sits in the print layout above the worksheet’s printed cells. It can contain a report name, department, file name, page number, or other information. It is not a row of cells, and it does not appear as an ordinary part of the worksheet while you work in Normal view.
A worksheet heading, by contrast, is text entered into cells, often in the first row. For example, a sales table might have the cell labels “Date,” “Region,” and “Revenue.” These labels are visible on the sheet, can be selected and edited like other cell contents, and can be used by Excel’s sort, filter, and table features. A third related term is the row and column headings: the numbered rows and lettered columns around the grid. Those are interface labels, not custom text headers.
- Use a page header when you want information printed at the top of pages.
- Use a worksheet heading row when you want column names inside the data.
- Use Freeze Panes when you want a worksheet row to stay visible while scrolling; it does not add a printed header.
Add a text header to printed pages
In Excel for Microsoft 365 on Windows, open the worksheet you want to print and follow these steps:
- Select Insert > Text > Header & Footer. Excel switches to Page Layout view and displays header and footer areas above and below the worksheet grid.
- Click the left, center, or right header box, depending on where you want the text to appear. The three boxes let you position content without inserting spaces to push it across the page.
- Type the text, such as “Quarterly Sales Report” or “Inventory Summary.” You can enter plain text, or combine typed text with fields such as a page number.
- Click a worksheet cell when you have finished editing the header. To check how it will look on paper or in a PDF, select File > Print and review the preview.
The header is associated with the worksheet’s page setup, so you may need to add it separately to other sheets in the workbook. In Excel for Mac, use Insert > Header & Footer as well; the workbook then displays the header and footer areas in Page Layout view. Ribbon placement and dialog wording can vary somewhat by platform and update, but the basic process is the same.
Excel for the web has fewer page-layout editing capabilities than the desktop app. If you do not see a way to create or edit the header there, open the workbook in the Excel desktop application. You can still use the web version for ordinary worksheet headings in cells.
Edit, move, or remove header text
To change an existing page header, return to Page Layout view or select Insert > Text > Header & Footer, click the relevant section, and edit its contents. Text in the left, center, and right boxes is independent. If a header appears off-center, check which box contains it rather than trying to align it with spaces. Different printer margins and page scaling can also affect how the result sits on the page.
To remove a header, click the section containing the text and delete its contents. Removing the text from one section does not necessarily clear the other two. For a more complete reset, open Page Layout > Page Setup using the dialog launcher in the Page Setup group, choose the Header/Footer tab, and set the header to “(none).” The precise dialog controls can vary slightly by Excel version.
Headers can be set differently for the first printed page or for odd and even pages. In the Page Setup options, look for choices such as “Different first page” and “Different odd and even pages.” These are useful for a cover page or a two-sided report, but they can make a header seem to disappear if you are looking at a page that uses a different setting. Check the relevant page before assuming the text was deleted.
Page headers versus worksheet heading rows
A page header is best for print-oriented details that should sit outside the data, such as a report title, confidentiality note, or page number. A heading row is best for labels that describe the actual columns. In a list of orders, for example, “Order ID,” “Customer,” and “Ship Date” belong in cells above the records. Excel can then recognize those labels when you convert the range to a table or apply filters.
Putting column names in a page header does not turn them into field names for sorting or analysis. Likewise, typing a report title into the first row of a dataset makes it a worksheet value, not a page header. Keeping these uses separate makes the workbook easier to print and work with. A common arrangement is a title in the page header and a separate, clearly formatted column-label row in the grid.
If you need column labels repeated on every printed page, do not copy the labels into a page header manually. Use Print Titles instead. On Windows, select Page Layout > Print Titles. In the Page Setup dialog, enter the row containing the labels in “Rows to repeat at top,” then confirm the setting. For example, if the labels are in row 1, specify that row as the repeating row. This repeats the actual worksheet row on each printed page, so the labels stay aligned with their columns.
Freeze Panes solves a different problem: keeping rows or columns visible while you scroll on screen. It does not make those rows repeat on printed pages. A workbook can use both Freeze Panes for screen navigation and Print Titles for paper or PDF output.
Formatting and useful automatic fields
When you click a header section, Excel shows a contextual Header & Footer tab. Its controls can insert items such as a page number, total pages, current date, current time, file name, file path, or worksheet name. These are fields rather than ordinary typed values: Excel fills them in when it displays or prints the page. They can save time on reports that are updated or printed repeatedly.
For example, a centered header might contain the report name, while the right section contains the current page number. You can also type explanatory words next to an inserted field. Use the ribbon’s field buttons to add a field rather than guessing its special code. A page number field is not the same as typing “1”: the field can show the appropriate number on each page.
The same contextual tab includes options for formatting header text and inserting a picture, such as a company logo. Keep logos appropriately sized; a large image can consume space and push worksheet content onto additional pages. Header content is constrained by the page margins and the available header area, so long text may be clipped or wrap in an unattractive way. Preview the printed pages after formatting, especially if the sheet is scaled to fit.
There is no need to place a header in a particular worksheet cell. It is stored as page-layout information for the sheet, not as a value in the grid. That also means it will not be included when you copy a cell range as data, although it is part of the worksheet’s print setup.
Common problems and practical fixes
- The header is missing in Normal view. That is expected: page headers are generally visible in Page Layout view and in print preview, not as grid cells in Normal view. Check File > Print before changing the content.
- The header prints on only one sheet. Header settings are applied to individual worksheets. Select another sheet and add or configure its header too. Grouping sheets can apply some layout changes to several selected sheets, but take care: edits made while sheets are grouped may affect all of them.
- The column names appear only on the first page. A page header does not repeat the worksheet’s heading row. Set Page Layout > Print Titles and choose the correct row under “Rows to repeat at top.”
- The text is cut off or too small. Shorten the wording, use a different section, or adjust the page margins and scaling. Inspect File > Print because the result depends on page size, orientation, margins, and printer settings.
- The header looks different in a PDF or on another printer. Page breaks, printable areas, and scaling can change with printer drivers or paper settings. Confirm the selected paper size and review the preview for the output device or PDF workflow you intend to use.
- A typed page number does not change from page to page. Replace the fixed number with the page-number field from the Header & Footer tab.
Headers are mainly a presentation and printing feature. If the same information needs to be searched, filtered, calculated, or exported as part of each record, store it in worksheet cells instead. This distinction prevents a report label from being mistaken for data that Excel can analyze.
Choosing the right approach
Choose based on where the text must appear and what readers need to do with it. For a title that should appear above printed pages, use a page header. For names that identify fields in a dataset, use a heading row in cells and consider formatting the range as an Excel table. For labels that should repeat when a long worksheet is printed, set Print Titles. For labels that should remain visible during scrolling, use Freeze Panes.
You can combine these features. A useful printed report might have “Monthly Returns” in the center header, a page number at the right, column labels repeated from row 4, and Freeze Panes applied so rows 1 through 4 stay visible during screen review. Each element addresses a different viewing situation rather than duplicating the same feature.
Frequently Asked Questions
How do I add a header in Excel?
Select Insert > Text > Header & Footer, click a left, center, or right header section, and type. Check File > Print to see the printed result.
How do I make a text header show on every printed page?
A page header normally appears on each page of that worksheet unless settings such as “Different first page” or odd/even headers change the layout. For column labels, use Page Layout > Print Titles and set the appropriate row under “Rows to repeat at top.”
Can I put column headings in an Excel page header?
You can type similar words into a page header, but they will not function as column labels. For sorting, filtering, tables, and analysis, put column headings in worksheet cells. Use Print Titles if those cell labels must repeat on printed pages.
Why can’t I see my header in Excel?
Switch to Page Layout view or open File > Print. A page header is not an ordinary cell value and usually is not displayed in Normal view.
Can I add a header in Excel for the web?
Excel for the web does not offer the full desktop header-editing workflow. Open the file in Excel for Microsoft 365 on Windows or Excel for Mac to create or change a page header; ordinary heading text can still be entered in cells in the web app.
Related
- Power Query Remove Leading Zeros Without Losing IDs
- Power Query Reference: What It Does and When to Use It
- Excel Data Validation: Can You Select Multiple Items?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Reading View: Change the Reading Pane LayoutTo change Outlook’s reading view, adjust the Reading Pane: in classic Outlook for Windows, go to View >…
- Excel Shortcut Keys: Examples for Everyday TasksExcel shortcut keys let you edit, format, calculate, and move around a workbook without repeatedly reaching for the…
- Excel Table Themes: Styles, Colors, and How to Change ThemIn Excel, “table themes” usually means the built-in table styles that control a table’s colors, borders, and visual…
- Excel Freeze Panes: Keep the Top Row and First ColumnTo keep both the top row and first column visible in Excel for Microsoft 365 on Windows, select…
- Edit Conditional Formatting in Google SheetsTo edit conditional formatting in Google Sheets, select a cell covered by the rule, open Format > Conditional…
- Excel Data Analysis: What It Can Do and Where It Falls ShortYes—Excel is a capable tool for data analysis, especially when you need to organize, clean, summarize, visualize, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.