To take the date off a printed Excel spreadsheet, turn off the header and footer entirely, or edit the built-in header/footer elements and delete the date code. You can also set a print area that excludes any date cell on the sheet. The fix depends on where the date comes from: a header/footer code, a cell in the grid, or a field baked into a saved print setting.

This guide separates those three sources, explains how Excel assembles each printed page, and gives exact steps for removing the date without breaking the rest of your layout.

How Excel builds a printed page from cells and page settings

Excel does not print the grid you see on screen. It renders a separate page description assembled from the worksheet cells, your page setup, and the header and footer layer. The header and footer sit outside the cell grid in the page margins. That separation matters because a date in the header is not a cell value and cannot be selected or deleted on the sheet.

The printed date usually arrives through one of three channels. The first is an automatic header or footer code, written as &D in the header/footer syntax. Excel expands &D into the system short date at print time, using the Windows or macOS regional short-date format. The second channel is a literal date typed into a cell inside the print area. The third is a saved setting in a template or workbook that carries a header definition forward every time you print.

The header/footer code system uses ampersand prefixes. &D prints the current date, &T prints the current time, and &P and &N print page number and total pages. The system date is read from the operating system at the moment of rendering, so the printed value can differ from the date you last saved the file. That is a common source of confusion: a workbook opened in March and printed in April will show April's date in the header even though nothing in the sheet changed.

Microsoft documents this header/footer syntax in its support library, and the behavior is stable across recent desktop versions. The key mechanism is that expansion happens at print preview and print time, not at save time.

Where the printed date actually comes from

Before changing anything, identify the source. Three origins account for nearly every case, and each has a different removal path.

An automatic header or footer code is the most common. It appears in Normal view only as a faint gray line above or below the grid. In Page Layout view it becomes editable text. You will see it clearly in Print Preview as a dated line in the top or bottom margin.

A cell-based date is the second origin. A report template may place a date in row 1, or a filter date may sit in a visible cell just outside the data table. If the print area includes that cell, the date prints. This is not a header issue, so header settings will not remove it.

A saved page setup is the third origin. Excel stores header and footer text inside the worksheet's page setup record. A workbook received from a colleague, or a template like an invoice or timesheet, can carry a header underlines like "Printed on &D." Editing cells will not touch it.

One counterintuitive detail: a header can look empty in Normal view and still print. If the header contains only a date code and no visible characters around it, the gray header line may be subtle or scrolled out of view. Always confirm in Print Preview or Page Layout view before assuming the header is blank.

The fastest reliable method is to clear the header and footer, then rebuild only what you want to keep.

Open the workbook and go to the worksheet you plan to print. Select File, then Print, and watch the preview. If a date appears in the top or bottom margin, it is a header or footer element.

Return to the sheet and choose Insert, then Header and Footer. This switches to Page Layout view and opens the Header and Footer tools on the ribbon. The top margin shows three editable zones labeled left, center, and right. Click into the zone holding the date. The date code appears as &[Date] or &D depending on version. Select that code and delete it with the Backspace or Delete key.

Repeat for the footer by choosing Go to Footer. When both zones are clean, click outside the margin or press Escape. Print Preview should now show no date.

If you want to remove everything rather than edit one field, use the Header and Footer dropdown on the Page Layout tab and choose None for both header and footer. For multiple sheets, select all relevant sheet tabs first, then apply the change; Excel applies page setup to every selected sheet.

A bulleted checklist for a clean pass:

Confirm the date source in Print Preview before editing anything. Delete the &D or &[Date] code, not the surrounding text you want to keep. Clear both header and footer zones; the date may be in either. Recheck Print Preview after each change, since view and print can diverge. Group sheet tabs when the same header applies to several sheets. Save the workbook after cleanup so the page setup record updates.

Two red-flag warnings are worth stating plainly.

Do not delete a date cell that feeds a formula elsewhere; check dependents first, since removing the value can cascade into errors. Do not assume a blank-looking header is empty in Normal view; a date-only header can hide in the margin line.

Cells, print areas, and the page setup record

If the date is in the grid rather than the margin, the header tools will not help. Two approaches work: exclude the cell from the print area, or clear the cell.

Print areas are stored per worksheet. Select the range you actually want to print, then choose Page Layout, Print Area, Set Print Area. A date sitting in row 1 outside the selected range will no longer print. If the date cell is inside the data block, you have two options: delete or clear the cell, or hide the row before printing. Hiding a row removes it from the printed output while keeping the data and formulas intact.

The page setup record is worth understanding because it explains why some fixes do not stick. Excel stores headers, footers, margins, orientation, and print areas inside the worksheet definition. Copying a sheet, importing a template, or pasting a table with formatting can bring a header along with it. That is why a workbook can print a date even after you clear the visible grid.

A practical comparison of the three removal routes:

Date source Where you see it Removal method Persistence
Header/footer code Print Preview margin Delete &D in Header and Footer tools Saved in page setup
Cell inside print area The grid itself Clear cell or hide row Saved in cells
Cell outside print area Grid, not in preview Set a tighter print area Saved per sheet
Template setting Any print of the file Edit header in the template source Saved in template

The table shows that the persistence column differs: header fixes live in page setup, cell fixes live in the grid, and both survive a save. A fix that seems to revert usually means you edited one copy while the template or a grouped sheet kept the old setting.

Dates that reappear, templates, and shared files

A date that returns after you delete it almost always comes from a file-level or template-level source. Common causes include a workbook template in your startup folder, an Excel template file used to create new workbooks, or a shared file where a colleague's copy still carries the header.

The startup folder mechanism is easy to miss. Excel can load a default template on launch, and any header defined there is inherited by new workbooks. If every new file prints a date, check the template, not the individual workbook. Microsoft's documentation on templates describes this inheritance behavior and is the authoritative reference for where template files live on each platform.

Grouped sheets are another return path. If several tabs were selected when you cleared the header, the change applied to all of them. If only one tab was active, the others kept the date. Select all tabs and repeat the header clear to fix every sheet at once.

Shared files add a human factor. If a teammate re-saves a copy with the original header, your fix is overwritten. In collaborative settings, agree on a stripped template and distribute that, rather than fixing each file after the fact.

Practical thresholds and a working sequence

Use this sequence to remove the date reliably in under a minute once you know the source. It moves from cheapest check to most persistent fix.

First, open Print Preview. This single step tells you whether the date is in the margin or the grid, which decides every later action.

Second, if the date is in the margin, go to Header and Footer tools, delete the &D or &[Date] code, and confirm in preview. This fixes the majority of cases.

Third, if the date is in the grid, set a print area that excludes it, or hide the offending row. Confirm that the row is not referenced by a visible formula before hiding.

Fourth, if the date returns across new files, inspect the startup template and remove the header there.

Fifth, if the file is shared, replace it with a cleaned template so the fix propagates.

A short timeline of what tends to happen during a cleanup session:

Step Action Typical time What you learn
1 Open Print Preview Seconds Date location: margin or grid
2 Open Header and Footer tools Seconds Whether &D code is present
3 Delete the date code Seconds Whether the margin is now clean
4 Recheck preview Seconds Whether a second zone holds the date
5 Set print area if needed Under a minute Whether a grid cell is the source
6 Test print or PDF export Under a minute Whether the fix persists on output
7 Check template if it returns Minutes Whether the source is file-level

Exporting to PDF is a useful test because the PDF inherits the same page setup. If the PDF is clean, the printed output will be too.

Limits, version differences, and what this cannot fix

Removal works the same way on Excel for Microsoft 365, Excel 2021, and Excel 2019 desktop. The Header and Footer tools and the &D code behave consistently. Excel for the web supports header and footer editing but exposes fewer zone controls, so a workbook cleaned on desktop is the safer path for web printing.

Some cases fall outside header and footer editing. A date embedded in a chart title, a text box, or a shape prints as part of the drawing object and must be edited where it lives. A date inside a picture or scanned image cannot be removed by Excel at all. A macro-driven report can rewrite the header each time it runs, in which case the fix belongs in the macro, not the page setup.

Version differences in date formatting also matter. The system date expands using the regional short-date format, so the same workbook can print month-first in one region and day-first in another. Removing the code avoids that ambiguity entirely. Microsoft's header and footer guidance covers the code syntax, and the company's page setup documentation describes how the record is stored per worksheet; both are authoritative references for the behavior described here.

What this cannot guarantee: a workbook that is regenerated by an external report tool, or printed through a third-party add-in that injects its own header, may reintroduce a date outside Excel's page setup. In those cases, the fix must be applied at the source tool. That is a limit of the document, not of the method.

The general rule is simple. A date in the margin is a header/footer code and gets deleted there. A date in the grid gets excluded from the print area or hidden. A date that returns gets fixed at the template or shared-file level. Identify the channel first, and the removal becomes a two-click operation.