Entering current date is easy and can be done in the print page setup.

Generally, headers and footers contain basic information about the spreadsheet such as page number, current date, workbook name, file path, etc.

Microsoft Excel provides a handful of predefined headers and footers to choose from, as well as allows creating your own ones.

By default, the central box is selected: If you wish the header to appear in the top left or top right corner of the page, click the left or right box and enter some information there.

To exit the header box without keeping the changes, press Esc.

To add a preset footer, please follow these steps, to make a custom Excel footer, see these guidelines.

This will display the worksheet in Page Layout view and get the Design tab to appear.

To see the codes, just click the corresponding header or footer text box.

If you have chosen to add a complex header or footer, chances are that different elements will be inserted in different boxes like in the above example.

To position the header or footer the way you want, you can move the inserted elements to other boxes by copying pasting their codes or add each element individually as explained in the next section.

Then, click one of the boxes at the top (header) or at the bottom (footer) of the worksheet and type your text there.

You can also enter different pieces of information by selecting one of the built-in elements on the Design tab, in the Header Footer Elements group.

As you can see in the screenshot below, this only displays the number: If you want the word Page to appear as well, click anywhere in the right text box, and type Page in front of the code, separating the word and the code with a space character like this.

For this, click the Picture button, browse for the image file, and click Insert.

The Picture code will be inserted in the header straight away.

For example, to include Products Services in the header or footer, you type Products Services.

If you enter the numbers manually, you will end up having the same number on each page.

To select multiple sheets, hold down the Ctrl key while clicking the sheet tabs.

To find out exactly what element a particular button inserts, hover over it to display a tooltip.

For example, this is how you can add a page number to the right hand side of your Excel header: You can also type your own text in any section as well as edit or remove the existing text or codes.

Please remember that a header and footer of chart sheets can only be edited in this way.

If all of the sheets are selected, click any sheet tab, and then click Ungroup Sheets in the context menu.

For example, the header text will become smaller when you select the Fit Sheet on One Page printing option.

I thank you for reading and hope to see you on our blog next week.

How To Change Title In Excel For Mac