ASAP Utilities for Excel - Clear All Headers and Footers in Selected Sheets

Clear All Headers and Footers in Selected Sheets

ASAP Utilities › Format & Layout  ›  3. Clear All Headers and Footers in Selected Sheets

This tool removes all content from the headers and footers in the selected worksheets.
It clears all six sections: left, center, and right for both the header and footer, making them fully empty again.

This is useful when:

  • Cleaning up templates or reports
  • Preparing sheets for printing or export
  • Removing outdated notes, file names, or timestamps from headers and footers

Only the selected sheets are affected.
The other layout and page setup settings remain unchanged.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords to help you find this tool:
Remove header and footer, Clear all headers and footers, Delete header and footer content, Empty header and footer, Delete all headers and footers, Remove header text, Remove footer info, Bulk clear header and footer, Reset headers and footers, Clear print headers, Batch remove header/footer, Clear custom header

Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial