How to Remove Headers and Footers from All Excel Worksheets
Question details
The user needs to completely remove headers and footers from all worksheets in an Excel workbook simultaneously.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Cleaning up a workbook for printing or sharing where headers and footers were previously applied across multiple grouped sheets.
- Observed behavior
- Headers and footers appear on all printed or exported pages and need to be cleared completely across every worksheet tab.
Before attempting to delete headers and footers across multiple sheets, make sure you have properly grouped all the target worksheets so that your changes apply to the entire selection at once.
Remove Headers and Footers Using Page Layout View
Group your worksheets and use the Page Layout view to manually delete headers and footers across all selected sheets simultaneously.
This method is highly visual and allows you to see exactly what you are deleting on the page. Because grouped sheets share page setup changes, clearing the header and footer on one sheet clears them on all grouped sheets.
Right-click on any worksheet tab at the bottom of the screen and select 'Select All Sheets' from the context menu. The sheet tabs will turn white, indicating they are grouped.
Navigate to the 'View' tab on the top ribbon and click on 'Page Layout' in the Workbook Views group.
Double-click the header area at the top of the page, highlight all the text or codes, and press the Delete key. Scroll down to the bottom of the page and repeat this process for the footer area.
Go back to the 'View' tab and click 'Normal'. Finally, right-click any sheet tab and select 'Ungroup Sheets' to ensure future data entry only affects the active sheet.
Clear Headers and Footers via Page Setup Dialog
Use the Page Setup menu for a quick way to set headers and footers to 'None' across multiple worksheets without changing your view mode.
Clear Headers and Footers Easily in WPS Spreadsheet
WPS Office provides a highly compatible and intuitive Spreadsheet program that lets you easily manage page layouts, headers, and footers across multiple sheets, offering a seamless experience for Excel users.
- 1. Group your sheets in WPS: Open your spreadsheet in WPS Office, right-click any sheet tab at the bottom, and click 'Select All Sheets'.
- 2. Access Page Setup: Navigate to the 'Page Layout' tab on the top menu and click the 'Page Setup' icon.
- 3. Remove the headers and footers: Switch to the 'Header/Footer' tab in the pop-up dialog box. Choose '(none)' from both the Header and Footer dropdown menus, then click 'OK'.
- 4. Ungroup the sheets: Right-click any sheet tab again and click 'Ungroup Sheets' to resume normal editing.
Frequently Asked Questions
Why are my headers and footers not deleting from all sheets?
This usually happens because the worksheets are not grouped. You must select all the sheets you want to modify (by right-clicking a tab and choosing 'Select All Sheets') before deleting the header or footer. If they are not grouped, changes will only apply to the active sheet.
Can I remove a header from the first page only?
Yes. Open the Page Setup dialog, go to the Header/Footer tab, and check the box for 'Different first page'. This allows you to leave the first page header blank while keeping the header intact for all subsequent pages.
How do I remove headers and footers before printing without deleting them permanently?
Excel does not have a feature to simply hide headers and footers during printing. To achieve this, you should save a copy of your workbook, delete the headers and footers using the Page Setup menu in that specific copy, and print from there to keep your original file intact.
Will deleting headers and footers affect my cell data?
No, headers and footers are strictly part of the page layout and print settings. Removing them will not alter any data, formulas, or cell formatting within the main body of your worksheet.
