Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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.


Download Practice Workbook


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

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.

how to add date and time in excel when printing

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.

Using Page Layout Option to Print Current Date and Time in Excel

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.

Editing Header and Footer to add date and time in excel when printing

  • 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.

Read More: How to Insert the Current Date and Time in Cell A1 (6 Easy Ways)


Similar Readings


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.

Utilizing Page Setup Dialogue Box to add date and time in excel when printing

  • 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.

Final output of method 2 to add date and time in excel when printing

Read More: How to Insert Static Date in Excel (4 Simple Methods)


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.

Using Header & Footer Option from Insert Tab to add date and time in excel when printing

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

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

Read More: How to Insert Last Modified Date and Time in Excel Cell


💡 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.

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. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!


Related Articles

Zahid

Zahid

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo