To delete a print header in Excel, open Page Layout > Page Setup using the small dialog launcher, choose the Header/Footer tab, set Header to (none), and select OK. If by “header” you mean the first row of worksheet labels or an Excel table’s header row, use the matching method below instead; those are different things, and deleting a row can remove data.
This guide is for Excel for Microsoft 365 on Windows. First identify what you want gone: a print header appears at the top of printed pages, a worksheet heading is text in cells, and a table header labels the columns of an Excel table. You do not need to install anything, but you should save the workbook before making structural changes.
What You’ll Need
- The Excel workbook containing the header you want to remove.
- Access to desktop Excel for the print-header steps. Excel for the web has limited support for editing page headers and footers; open the file in the desktop app if you cannot access the setting.
- A quick check of whether the header is printed page text, worksheet cell content, or a table label. If you are unsure, use Print Preview or click the suspected text to see whether a cell becomes selected.
Step-by-Step
- Save a copy or save your current workbook. Removing a print header is easy to reverse, but deleting a worksheet row can remove information and may affect formulas, charts, and references. Use File > Save As if you want a separate copy to work on. For ordinary edits, Ctrl+Z on Windows undoes the last action; on Mac, use Command+Z.
- Decide which kind of header you mean. If text appears above the grid when you print or view a page in Page Layout view, it is a print header. If the words are in row 1 or another row of cells, it is worksheet content. If the range has filter arrows and table styling, the labels are probably an Excel table header. This distinction matters: removing a print header will not alter cells, while deleting a row can.
- Remove a print header from the worksheet’s page setup. Select the worksheet tab you want to change. Open Page Layout, find the Page Setup group, and click its small dialog box launcher at the lower-right corner. In the dialog, select Header/Footer. Open the Header drop-down list, choose (none), and click OK. This removes the header from printed pages for that worksheet. Repeat for other sheets if each one has its own header; selecting several sheet tabs together can apply page setup changes to all selected sheets, but remember to ungroup them afterward by clicking a single tab.
- Check whether a special first-page or odd/even setting is involved. In the same Header/Footer tab, look for options such as Different first page and Different odd and even pages. When these are enabled, a sheet can have different header content on different pages. Choosing (none) in the Header list is usually the simplest way to clear the header across the selected sheet. If you need to preserve a special header on some pages, inspect the relevant page sections in Page Layout view and remove only the unwanted content.
- Alternatively, clear the print header directly in Page Layout view. Select View > Page Layout, or use the Page Layout view button near the workbook’s status bar if it is visible. Click the header area at the top of the page. A header can have left, center, and right sections; click each section that contains text or a field code, such as a page number, and remove its contents. Click a worksheet cell when finished. If you do not see header boxes, switch to Page Layout view or use the Page Setup dialog method above. To return to the normal grid, choose View > Normal.
- Remove a worksheet heading without deleting its row. If the “header” is simply text in cells, select the cells containing that text and press Delete. This clears the cell contents but leaves the row, its formatting, and the cells below in place. On Windows, you can also use Home > Clear > Clear Contents. On Mac, select the cells and press Delete or use the Clear command on the Home tab, depending on your ribbon layout. Review any formulas or instructions that relied on those labels before clearing them.
- Delete a worksheet row only if you intend to remove the entire row. If the labels occupy a row that should be removed along with its cells, click the row number at the left edge to select the whole row, right-click, and choose Delete. This shifts the rows below upward. Do not choose this just to make the text disappear: it can remove values elsewhere in that row, change references, and affect the layout. If you need to keep other cells in the row, clear only the specific heading cells instead.
- Hide a table header row when you want the table display without visible labels. Click inside the table so its contextual tab appears, then open Table Design and clear Header Row in Table Style Options. This is a display choice, not the same as deleting a normal worksheet row. The table still uses column names internally, and turning off the header row also hides its visible labels and filter controls. If you need filters or clear column names, keeping the header row and changing its text may be a better choice. To show it again, return to Table Design and select Header Row.
- Confirm the result in the right place. For a print header, select File > Print and check the preview; also inspect more than the first page if the sheet spans multiple pages. For a worksheet heading or table header, return to the grid and confirm that the correct cells or labels changed and that nearby data remains intact. Save the workbook when the result is right.
Common Mistakes
Deleting the first row when you meant to remove a print header. A print header is stored in page setup, not in row 1. Deleting row 1 can remove column names or data and does not necessarily change the printed header. Use the Header/Footer setting for text that repeats above printed pages.
Clearing cells when you meant to delete the row. Pressing Delete clears selected cell contents, but the row remains. That is often what you want when removing labels while preserving layout. If the whole row should go, select its row number and use Delete from the context menu.
Confusing a table heading with a page header. Table headers are part of the data structure and commonly provide filter buttons. Clearing or deleting those cells can cause Excel to create replacement labels or change how the table behaves. Use the Header Row option when you only want to hide that row visually.
Changing the wrong sheet or page section. Each worksheet can have its own print settings, and first-page or odd/even options can make headers differ. Check the selected sheet tab and inspect the print preview before assuming one change affected every page in the workbook.
Tips
- Use View > Page Layout to recognize a print header: it sits in a page margin above the worksheet grid, rather than in a numbered row.
- Use File > Print to verify printed output. Normal view does not show all page setup details, so a header can seem absent on screen while still appearing in print preview.
- If you want to keep a worksheet’s column labels but remove their bold fill or color, change the formatting rather than clearing the cells. Select the cells and use the options on the Home tab.
- Before deleting a row, check whether it contains anything besides the heading, including hidden cells or formulas. Selecting the row number makes it easier to see that the command will affect the whole row.
- When worksheets are grouped, a change may apply to multiple sheets. If several tabs are highlighted, right-click a selected tab and choose Ungroup Sheets after the edit, or click an individual sheet tab.
- For a table, renaming a heading is often safer than removing it. Click the heading cell, enter a clearer label, and press Enter; the table keeps its column structure and visible controls.
Troubleshooting
The header still appears in print preview. Confirm that you edited the correct worksheet, then reopen Page Layout > Page Setup and check the Header/Footer tab. If different first-page or odd/even pages are enabled, inspect those settings as well. Also check whether the text is actually in the first worksheet row: cell content will print even after a page header is removed.
You cannot find the Page Setup dialog launcher. Make sure the Page Layout tab is selected and look at the lower-right corner of the Page Setup group. If the Excel window is narrow, ribbon groups may be compressed; maximize the window or use the group’s available menu. You can also select View > Page Layout and click the header area directly.
The header area is not selectable. Switch to View > Page Layout and click near the top margin of the page, not inside a worksheet cell. If you are using Excel for the web and cannot edit it, choose the option to open the workbook in the desktop app, then use the Page Setup method.
Deleting the heading caused data to move or formulas to change. Press Ctrl+Z on Windows or Command+Z on Mac immediately to undo, if the action is still available. Then select only the heading cells and clear their contents, or use the table’s Header Row setting. If you have already saved or closed the workbook, restore a previous version or recover the original copy if available.
The table has generic labels after you hide or remove its headings. Excel tables need column names for their internal structure. Turn the table’s header row back on if you want visible labels and filters, or rename the columns to useful headings. If you do not need table features, you can convert the table to a regular range using Table Design > Convert to Range, then edit the cells as ordinary worksheet content. Check the result before saving because this changes the table structure.
Frequently Asked Questions
Does deleting a header in Excel delete my data?
Not if you set the print header to (none); that changes page setup only. Clearing header cells removes their contents, while deleting a worksheet row removes all cells in that row and shifts the rows below.
How do I remove a header from every page I print?
Choose the worksheet, open Page Layout > Page Setup, select Header/Footer, set Header to (none), and click OK. Check print preview, especially if the sheet has different first-page or odd/even settings.
Can I remove only the page number from a header?
Yes. In View > Page Layout, click the header section containing the page number and delete that field, leaving other header text in place. Alternatively, edit the header through the custom header controls in the Page Setup dialog.
How do I delete a column heading but keep the data below it?
Select only the heading cell or cells and press Delete; do not select the row number. If the cells belong to an Excel table, consider renaming the labels or changing the table’s header-row display because tables rely on column names.
Why does my Excel table still need a header row?
Excel tables use column names to identify fields, support structured references, and provide features such as filter controls. You can hide the visible header row with Table Design > Header Row, but that is different from removing the table’s internal column names.
Can I edit print headers in Excel for the web?
Web support is limited and some header or footer changes require desktop Excel. Open the workbook in the desktop app and use the Page Setup dialog if the header cannot be selected or changed in your browser.
Related
- Copy Link in Excel: Steps for Cells, Files, and Sheets
- How to Copy Multiple Rows in Excel
- How to Copy Merged Cells in Excel Without Losing Layout
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Make One Page Landscape in Word 365: Step by StepTo make one page landscape in Word 365 while keeping the rest of the document portrait, isolate that…
- Convert to Dropdown in Google Sheets: Setup and TipsTo convert cells to a dropdown in Google Sheets, select the cells, choose Insert > Dropdown, add the…
- Date Excel Shortcut: Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (semicolon) to insert today’s date as a fixed value…
- ISNUMBER in Excel: Check Whether a Cell Holds a NumberTo check whether a cell contains a number, enter =ISNUMBER(A2) in another cell, replacing A2 with the cell…
- Excel File Opening Blank? Causes, Checks, and FixesIf an Excel file opens to a blank screen, first check whether the workbook or its sheets are…
- Excel WEEKDAY: Get the Day of the Week from a DateIn Excel, use WEEKDAY to return a number for the day of the week represented by a date.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.