OmniDocPrint an Excel Sheet Without Header and Footer
Remove the header and footer from an Excel sheet before printing, with a pre-print check, step-by-step settings, and a fix for PDFs that already have them.
When you print an Excel sheet, the program often adds a header and footer you did not ask for: a file name, a date, a page number, or a sheet tab name pulled from a template. For a financial table or a data export going to a client, that extra text can look unprofessional or push the printout onto an extra page. This guide shows you how to print an Excel sheet without a header and footer, check the result before you use paper, and handle the case where the header is already baked into a PDF.
The short fix is to clear the header and footer in the sheet's page settings, not in the cells themselves. Once both are empty, Excel prints only the data you see on the sheet. The steps below cover this for a standard workbook, plus a route for PDFs you have received.
How do I print an Excel sheet without header and footer? The short answer
Clear the header and footer fields in the sheet's Page Setup, then confirm the change in print preview before printing.
| Your situation | What to do | Why |
|---|---|---|
| You created the workbook and want a clean printout | Clear both header and footer in Page Setup, then preview | Headers and footers are print settings, so cell edits won't remove them |
| The workbook has several sheets | Select all sheets first, then clear the header and footer | Otherwise the leftover header or footer prints on the untouched sheets |
| You only want to repeat column titles on each page | Use print titles, and leave the header and footer empty | Repeated rows are a different setting from a page header |
| You received a PDF that already has a header | Open it in the OmniDoc PDF editor and redact or edit the header area | The header is part of the file, so you need to change the PDF itself |
| You want to tidy the sheet before printing | Edit the data in the UniCell spreadsheet in the desktop client | The facts don't cover its print settings, so confirm them in the app first |
Before you start
Check these points so you don't clear the wrong thing or print with the wrong layout.
- Open the workbook you plan to print, not an older copy. Templates often carry old headers, and a copy may have settings you don't expect.
- Decide whether you need any header or footer text. A page number is useful for a multi-page report. If you need it, clear only what you don't want rather than everything.
- Note the print area, if you set one. Print area controls which cells print. Clearing headers does not change it, so a wrong print area will still show up on paper.
- Have a printer or PDF output ready for the preview. You need to see the final pages to confirm the header is gone, and a preview is a simple way to check.
- Know which sheets you need. Each sheet keeps its own page settings unless you select several sheets together, so list the ones that go into the printout.
Removing the header and footer from an Excel sheet, step by step
- Open the workbook and select the sheet. Click the tab of the sheet you want to print. If you need several sheets, hold the Ctrl key (or Command on a Mac) and click each tab so all of them are selected together.
- Switch to Page Layout view. Headers and footers only appear in this view, so it shows you exactly what will print. It's easier to spot a stray header here than in the normal grid.
- Open Page Setup. Use the print or page setup options to open the Page Setup window, which holds the header and footer controls for the sheet.
- Clear the header. Go to the header and footer section, then set the header fields to empty. Clear any custom text in the left, center, and right header boxes.
- Clear the footer. Do the same for the footer boxes, so no file name, date, or page number remains.
- Confirm and close. Click OK to apply the change. If you selected several sheets, the change applies to all of them.
- Preview before printing. Open print preview and scroll through every page. The header and footer area should be blank on each one.
- Print or export. Print the sheet, or save it as a PDF if the output goes to someone else.
Check the result
Look at the printout or preview before you send it. Use this table to find and fix common problems.
| Check | How to see it | If it's wrong |
|---|---|---|
| Header area is blank | Look at the top margin in Page Layout view or print preview | Reopen Page Setup and clear the header boxes again |
| Footer area is blank | Look at the bottom margin in print preview | Clear the footer boxes, including any page number |
| Every sheet is clear | Click each sheet tab and check its preview | Repeat the steps for any sheet that wasn't selected |
| Column titles still repeat | Check page 2 onward in preview | If you want them, set print titles; if not, remove them |
| Data is complete | Compare the last page with the sheet | Adjust the print area so the right cells are included |
If a header still prints after you cleared it, a likely cause is that you changed only one sheet. Select all the sheets in the workbook and clear the settings again.
🎯 Which approach fits you?
Your starting file decides the route, so pick the one that matches what you have.
- You own the Excel file. Use the Page Setup steps above. This is a direct fix and keeps your data unchanged.
- You received a PDF with a header. The header is already part of the file, so editing the Excel source is not an option. Open the PDF in the OmniDoc desktop client's PDF editor (download it at https://download.omnidoc.top), then use redact on the header text. Redaction removes the content for good, so check the page afterward for leftover blank space or cut-off text.
- The header is plain text you can edit. If the PDF editor lets you change the text in place, you can remove or blank the header text instead of redacting it. Results vary by file, so confirm the page after each change.
❓ FAQ
1. Why does Excel print a header even when I never added one?
Some templates and workbooks saved from other computers include a header or footer in their page settings. Those settings travel with the file, so you won't see them in the cells. Clearing them in Page Setup removes them.
2. Will clearing the header change my data?
No. The header and footer are print settings only, so your cell values, formulas, and formatting stay the same. The only change is what prints in the top and bottom margins.
3. How do I stop repeated column titles from printing on every page?
Repeated titles are set as print titles, which is a separate option from the header. Remove or change the rows set to repeat in that setting, then check page 2 in print preview to confirm.
4. Can I remove a header from a PDF I didn't create?
Yes, if the header is text in the file. The OmniDoc PDF editor can redact it, and in some files you can edit the paragraph text in place. Always check the result, because redaction permanently removes the content from that area.
📝 Summary
Clearing the header and footer in an Excel sheet's Page Setup is the direct fix, and you should always check every sheet in print preview before you print. For PDFs that already have a header, edit or redact the file itself, then review the page. Keep the Page Layout view handy so you can see exactly what will print.
