If you’re like most people, you probably have a spreadsheet with all of your data spread out on different sheets. But if you want to make your spreadsheet header and footer different colors, there are a few steps you can take to make that happen. First, open the spreadsheet in Excel and create a new sheet. Name the sheet Header and Footer. On this sheet, add a list of values for the following: Header Color: The color of the header in your spreadsheet should be blue or black. Footer Color: The color of the footer in your spreadsheet should be green or white. Next, add some basic formulas to these values so that they will change when you save the sheet as a file: =COUNT(*) (colors) This will add up the number of cells in each row and column in the Header and Footer sheets, and then change those colors accordingly. Save the file as Header_Footer.xlsx and enjoy your new header and footer colors!
You can add text, such as page numbers, filename, worksheet name, and date, to the header and footer on your spreadsheet. But, what if you want the first page of your worksheet to have a different header than the rest? That’s an easy task to accomplish.
NOTE: We used Excel 2016 to illustrate this feature.
To make header and footer on the first page of the current worksheet different from the rest of the pages, click the “Page Layout” tab.
In the “Page Setup” section, click the “Page Setup” button in the lower-right corner.
The “Page Setup” dialog box displays. Click the “Header/Footer” tab.
Click the “Different first page” check box so there is a check mark in the box.
Once you’ve turned on the “Different first page” option, you can customize the header for the first page of the spreadsheet and the header for the rest of the pages. Click “Custom Header”.
The “Header” tab is where you specify the header for all the pages after the first page, which, in our example, is the page number and the total number of pages. For the first page of your spreadsheet, you may want to leave the header blank, which is the default. However, for our example, we’ll add different text. To do so, click the “First Page Header” tab.
Click in the “Left section” box, “Center section” box, or “Right section”, depending on where you want to put the content of your header. You can have content in all three boxes. We’re going to add the filename to the center of the header, so click in the “Center section” box and then click the “Insert File Name” button.
To accept your changes and close the “Header” dialog box, click “OK”.
You’re returned to the “Page Setup” dialog box. Click “OK” to close it.
We created a custom header in this example, but you can also create a custom footer in the same way using the “Custom Footer” button on the “Page Setup” dialog box.
You can also use this dialog box to make the header and footer different for odd and even pages, by selecting the “Different odd and even pages” check box on the “Header/Footer” tab on the “Page Setup” dialog box. Then, you can customize the different headers and footers for the odd and even pages using the “Custom Header” and “Custom Footer” buttons.
