How to add header or footer to all worksheets/pages in Excel?

There are times when you may need to work on individual parts of a report that are part of a larger report, but you have to work on them individually. For example, if you complete a report weekly or monthly, you might have a tab for each report within the same Excel file.

But those individual worksheets would possibly want to be published with headers and footers, and the same can be used for every worksheet. Even in case you are surely copying and pasting the equal factor to every sheet, there are a shockingly wide variety of steps concerned to add information to an Excel Header.

There may be a manner to use a header to each worksheet for your workbook at the same time with the aid of first choosing all the worksheets, then really creating the header or footer on certainly one of them. This change will then be applied to every worksheet for your workbook.

Adding Header or Footer to All Worksheets in Excel

You can follow the steps given below to understand how adders or footers can be added to all worksheets in Excel.

Step 1

Open the Excel sheet that you want to modify. Right-click on the sheet tab at bottom of the window, and then select All Sheets.

Step 2

Click the Page Layout tab at the top of the worksheet.

Step 3

Click the small page set-up button at the bottom-right corner of the page set-up.

Step 4

Click the Header/Footer tab.

Step 5

Click the Custom Header button, as shown below.

Step 6

Add your header information where ever you needed. In this example header information is mentioned in the middle.

The name is what I’ve mentioned in this example.

Step 7

Next, click the Custom Footer button, as shown below.

Step 8

In this same way, add your footer information where ever you needed. In this example header information is mentioned in the middle and then click on OK > OK.

"Task completed" is what I’ve mentioned in this example. The following screenshot shows the header information.

The following screenshot shows the footer information.

Go to File and then select Print, now you can see the preview of your header and footer information on how everything looks like.

When it comes to making the same changes to multiple cells in a Microsoft Excel sheet, it is usually possible to do so by selecting all of the cells in the worksheet that need to be changed. The same rule applies to completing the worksheet in Excel, one of the things you can edit in bulk are headers or footers.