Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more

Excel worksheet headers and footers are hidden in Normal view by design; they appear in Page Layout view, Print Preview, and on printed pages. Switch to View > Page Layout or open File > Print to check them. If you’re using Excel for the web, open the workbook in desktop Excel: the web app cannot insert footers and does not display footers added in desktop Excel.

First, check the worksheet view

A header or footer may be present even when it is not visible beside the worksheet cells. Microsoft says worksheet headers and footers display only in Page Layout view, Print Preview, and on printed pages; their absence in Normal view does not mean they were deleted.

  • To see them while working on the sheet, select View > Page Layout. You can also switch to Page Layout from the status bar.
  • To inspect the page as it will print, select File > Print and review Print Preview.
  • To return to the regular cell-focused view, select View > Normal.

Microsoft documents these instructions for Microsoft 365 and Excel 2024, 2021, 2019, and 2016. Microsoft’s worksheet header and footer instructions explain the available views and controls.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Check whether a header or footer is configured

In Page Layout view, select Insert > Header & Footer. Excel displays the header boxes at the top of the page and footer boxes at the bottom. Select a left, center, or right box to inspect or edit its content.

#1 Best Overall
Sale
Microsoft Excel Laminated Two-Sided Keyboard Shortcut Guide - Windows Edition
  • Over 215 Microsoft Windows Excel Shortcuts
  • Two-Sided Durable Laminiated Sheet
  • Designed for Excel on a Windows Computer

You can also open the worksheet’s Page Setup dialog and choose the Header/Footer tab to view custom header and footer controls. If you are editing several worksheets together, Microsoft documents selecting multiple sheet tabs and using Page Setup to apply settings across them.

If you’re using Excel for the web, switch to desktop Excel

Excel for the web has a specific limitation: it cannot insert a footer, and it does not display a footer inserted in desktop Excel. Microsoft also says page numbers cannot be inserted, viewed, or printed in Excel for the web. Open the workbook in desktop Excel to work with footer or page-number features.

Rank #2
Sale
Microsoft Surface Pro Keyboard with Pen Storage, Compatible with Copilot+ (11th Edition), Surface 9 and 8, Alcantara Material, Black
  • Instant Copilot. Unlock new possibilities with the dedicated Copilot key, which gives you instant access to experiences that can enhance your productivity¹.
  • Enhance your experience With the new microphone mute key and snipping key
  • Full keyboard experience. Features a full mechanical keyset, backlit keys, and a large trackpad for precise navigation and control. Optimal key spacing allows fast, fluid typing.
  • Slim and compact Performs like a traditional, full-size keyboard.
  • Clicks in place instantly Use in combination with the Surface Pro (11th Edition), Pro 9 and Pro 8* kickstand for a perfect laptop experience anywhere.

These limitations are documented in Microsoft’s pages on inserting a date in an Excel footer and inserting page numbers.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

If the problem happens only on certain printed pages

First page is missing the header or footer

In the Header & Footer tools, check whether Different First Page is enabled. This setting removes headers and footers from the first printed page.

Rank #3
Pixiecube Excel Cheat Sheet Desk Pad | Excel Shortcut Keys Mouse Pad | Extended Large XL Gaming Mousepad | PC Office Spreadsheet Keyboard Mat | Non-Slip Stitched Edge
  • EXCEL SHORTCUTS. ZERO SEARCHING. – Our bestselling reference mat puts an extensive collection of commonly used commands, formulas and helpful tricks directly beneath your fingertips so you can find answers fast, work smarter and stay in the flow.
  • YOUR DESK. SMARTER. – Clearly organized sections for navigation, selection, formatting, data and functions make it easy to find the right Excel command exactly when you need it.
  • LEARN, WORK & RESET – Built-in desk-exercise diagrams give you 10 quick ways to stretch, recharge and return to work feeling sharper.
  • ROOM TO WORK & CREATE – The extended 31.5 x 11.8-inch Pixiecube desk mat fits a laptop or keyboard and mouse, while the soft 2 mm surface adds comfort and protects your desktop.
  • BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.

Odd and even pages look different

Check Different Odd & Even Pages. When enabled, odd and even pages can use different header and footer content.

Microsoft describes both options in its worksheet header and footer guidance.

Rank #4
Sale
Incase Wired Keyboard 600 – Designed by Microsoft – Spill Resistant, Quiet Touch Keys, Plug and Play, 4 Hotkeys, Windows Start Key – Black
  • Efficient Media Controls: The Wired Keyboard 600, designed by Microsoft, features a Media Center with four hot keys for easy control of play/pause, volume up, volume down, and mute functions.
  • Quiet and Responsive Keys: Enjoy a comfortable typing experience with quiet, thin-profile keys that are both responsive and efficient.
  • Convenient Shortcuts: Quickly access common tasks with dedicated shortcut keys, including a calculator hot key and a Windows start screen key.
  • Spill-Resistant Design: Work confidently with a spill-resistant design that protects your keyboard from accidental messes.
  • Plug-and-Play Simplicity: No software needed—just connect the keyboard to your PC and start using it right away, with a full number pad for efficient data entry.

If the text is too small or misplaced in print

Header and footer display can be affected by print layout settings. In Page Setup, check whether Scale with Document is enabled if the header or footer text appears too small or too large relative to the worksheet. Check the Header/Footer margin as well: it should be smaller than the page’s top or bottom margin and at least as large as the printer’s minimum margin.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Use Print Preview to check the result. For help with page margins, see Microsoft’s worksheet margin instructions.

Best Value
SYNERLOGIC Microsoft Word/Excel (for Windows) Reference Guide Keyboard Shortcut Sticker, Laminated, No-Residue Vinyl (White/Small)
  • 💻 ✔️ EVERY ESSENTIAL SHORTCUT - With the SYNERLOGIC Reference Keyboard Shortcut Sticker, you have the most important shortcuts conveniently placed right in front of you. Easily learn new shortcuts and always be able to quickly lookup commands without the need to “Google” it.
  • 💻✔️ Work FASTER and SMARTER - Quick tips at your fingertips! This tool makes it easy to learn how to use your computer much faster and makes your workflow increase exponentially. It’s perfect for any age or skill level, students or seniors, at home, or in the office.
  • 💻 ✔️ New adhesive – stronger hold. It may leave a light residue when removed, but this wipes off easily with a soft cloth and warm, soapy water. Fewer air bubbles – for the smoothest finish, don’t peel off the entire backing at once. Instead, fold back a small section, line it up, and press gradually as you peel more. The “peel-and-stick-all-at-once” method only works for thin decals, not for stickers like ours.
  • 💻 ✔️ Compatible and fits any brand laptop or desktop running Windows 10 or 11 Operating System.
  • 💻 ✔️ Original Design and Production by Synerlogic Electronics, San Diego, CA, Boca Raton, FL and Bay City, MI, United States 2020. All rights reserved, any commercial reproduction without permission is punishable by all applicable laws.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

For charts and chart sheets, use Page Setup

Header and footer controls for charts and chart sheets are handled through the Page Setup dialog rather than the ordinary worksheet editing route. If the missing header or footer belongs to a chart or chart sheet, open Page Setup and inspect its Header/Footer options.

Quick troubleshooting order

  1. Switch to View > Page Layout or inspect File > Print.
  2. In Page Layout view, select Insert > Header & Footer and inspect the left, center, and right boxes.
  3. If you are in Excel for the web, open the workbook in desktop Excel to work with footers or page numbers.
  4. If only the first page is affected, check Different First Page; if odd and even pages differ, check Different Odd & Even Pages.
  5. If print placement or size is wrong, review Scale with Document and the Header/Footer margins, then verify in Print Preview.
  6. If the content belongs to a chart or chart sheet, use Page Setup.

For additional print steps, Microsoft’s worksheet and workbook printing guide covers print preview and printing.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Free tools Windows power users keep installed

One-click scans. No signup required.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.