how can I insert headers and footers at the same time on every sheet in an Excel file?

Hi @Gianluigi, 

Thank you for posting your question in the Microsoft Q&A forum. 

Regarding your requirement to insert a header or footer on multiple sheets at the same time, please follow the step-by-step instructions below: 

Steps to Add a Header or Footer to Multiple Sheets 

1. Select all sheets  Right-click any sheet tab at the bottom of the workbook.  Click Select All Sheets. 
2. Open Header & Footer  Go to View > Page Layout.  Click in the header or footer area of the worksheet. 
3. Insert your header or footer  Type the text directly, or  Use the Header & Footer Elements options as needed. 
4. Ungroup the sheets  Right-click any sheet tab.  Click Ungroup Sheets. 

After completing these steps, all selected sheets will display the same header or footer, without the need to manually add it to each individual sheet. 

Thank you again for your time and understanding. I truly appreciate your patience, and I’m happy to help if you need any further assistance. I look forward to your response. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread