How to Add Date and Time in Excel When Printing (3 Easy Ways)

While working in Excel, we often need to add date and time to our spreadsheets when printing them. Adding the date and time allows us to track the activities in the spreadsheet. It also acts as an indicator of the latest update of the worksheet. So, it is pretty helpful to add date and time in Excel sheets when printing. Don’t worry! Excel provides some swift tricks to add date and time effortlessly when printing.

How to Add Date and Time in Excel When Printing: 3 Simple Methods

In this section of the article, we will learn 3 simple methods to add date and time in Excel when printing. Let’s say, we want to print a monthly loan payment schedule. We have a payment table as shown in the following image. Our goal is to add the date and time to the worksheet.

Not to mention that we have used the Microsoft Excel 365 version for this article; you can use any other version according to your convenience.

1. Using Page Layout Option to Print Current Date and Time

Using the Page Layout option from the View tab of Excel is one of the smartest ways to add date and time when printing. We can do this by following some easy steps. Let’s follow the steps discussed below.

Step 01: Enabling the Page Layout Option

Firstly, go to the View tab from Ribbon.
After that, choose the Page Layout option from the Workbook Views group.

Consequently, you will see that the options to add header and footer are available as marked in the image below.

Step 02: Editing Header and Footer

Firstly, click on the area where you want to add the date to make the Header & Footer tab visible. In this case, we will be adding the date to the center footer and the time to the right footer.

Now, go to the Header & Footer tab from Ribbon.
Then, choose the Current Date option.

Now, click anywhere on the worksheet and the date will be added as shown in the image below.

After that, click on the right section of the footer.
Subsequently, go to the Header & Footer tab from Ribbon.
Then, choose the Current Time option from the Header & Footer Elements group.

Following that, click anywhere on the worksheet and you will get the time added to the right section of the footer as demonstrated in the following image.

Subsequently, press the keyboard shortcut CTRL + P to open the Print Preview mode and you will see that both the date and time are added to the worksheet.

2. Utilizing Page Setup Dialogue Box

Utilizing the Page Setup dialogue box is another efficient way to add date and time when printing. Let’s follow the procedure mentioned below to do this.

Steps:

Firstly, use the keyboard shortcut ALT + P + SP to directly open the Page Setup dialogue box from your worksheet.

As a result, the Page Setup dialogue box will open on your worksheet as shown in the following image.

Following that, in the Page Setup dialogue box, go to the Header/Footer tab.
Then, choose the Custom Footer option.

Consequently, the Footer dialogue box will open.

Now, in the Footer dialogue box, click on the Center section.
After that, select the Insert Date option.
Next, click on the Right section.
Subsequently, choose the Insert Time option.
Lastly, click on OK.

As a result, you will be redirected to the Page Setup dialogue box and click on OK there.

Following that, press the keyboard shortcut CTRL + P to open the Print Preview mode

Consequently, you will see that both the date and time are added to the worksheet as demonstrated in the following image.

3. Using Header & Footer Option from Insert Tab

Using the Header & Footer option from the Insert tab is one of the easiest ways to add date and time when printing. Let’s follow the steps given below to do this.

Steps:

Firstly, go to the Insert tab from Ribbon.
Following that, choose the Header & Footer option from the Text group.

As a result, you will see that the options to add header and footer are available as shown in the following picture.

Now, follow the steps mentioned in Step 02 of the 1st method.

Consequently, you will see that the date and the time are added to your worksheet as marked in the image below.

💡 Things to Remember

One thing to keep in mind is that you can see the header and footers only in the Page Layout view. If you can’t see the header and footers in your worksheet, most likely you are in the Normal View.

Download Practice Workbook

Adding Date and Time.xlsx

Conclusion

That’s all about today’s session. I strongly believe that this article was able to guide you to add date and time in Excel when printing. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality.

<< Go Back to Timestamp | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!