how to insert current date in excel footer

Clicking on it will automatically place the file in Page Layout and display the header.Īs shown in the screenshot given below, when you are clicked in the header or footer, the Design Tab on the Header & Footer Tools category is displayed.In the Text group on the right side of the Ribbon, click on Header & Footer.In the example above, the title of the file appears in the middle section. If you click in any one of the sections of the header or footer, you can type in any freeform text you want and it will appear on every page. To switch views, click the button in the lower-right part of the screen as in the picture below: They are especially useful if your purpose for using Excel is to create a printed or PDF version of your sheet.īy default, Excel spreadsheets appear in Normal mode, but headers and footers are displayed in Page Layout View. They add organization and clarity to Excel worksheets. The purpose of headers and footers in Excel mirrors that of hard copy documents. They can contain information such as page numbers, a date and/or time, title, or picture (like a logo).

The information in these sections remains constant across all the pages. When you point the cursor over the date, it will become gray – to edit it, just click on the gray field and type in the new date.In Excel, headers and footers are the sections of the worksheet that appear at the top and bottom of the pages in an Excel worksheet. Note that you’ll be able to change this field manually.

After the dialogue box with date and time formats opens, check the Update automatically box right above the OK button.

To do this, add one step to the previous process as follows. Inserting them as a field makes it possible to have them update every time the document is opened. The current date (and time) will be inserted as text.

Choose the one you want and confirm by clicking OK at the bottom.

A new dialogue box will open, showing you different date and time formats.In the Text section, choose Date & Time.Go to the Quick Access Toolbar and click on Insert – it’s the third tab, right after File and Home.You can do it without typing it yourself if you use the Insert Date and Time option. Sometimes you’ll need to insert the current date and time as soon as you open a new Word document and start typing. For instance, do you know how to automatically insert date in a Word document? You’re about to find out.

How to insert current date in excel footer