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.
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.
Read More: How to Insert the Current Date and Time in Cell A1 (6 Easy Ways)
Similar Readings
- How to Convert Unix Timestamp to Date in Excel (3 Methods)
- Convert Active Directory Timestamp to Date in Excel (4 Methods)
- How to Convert SAP Timestamp to Date in Excel (4 Ways)
- Convert Timestamp to Date in Excel (7 Easy Ways)
- How to Remove Timestamps from Date in Excel (4 Easy Ways)
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.
Read More: How to Insert Static Date in Excel (4 Simple Methods)
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.
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
- Excel VBA: Insert Timestamp When a Macro Is Run
- How to Insert Excel Timestamp When Cell Changes Without VBA (3 Ways)
- Insert Timestamp in Excel When Cell Changes (2 Effective Ways)
- How to Insert Excel Date Stamp When Cells in Row Are Modified
- Automatically Insert Timestamp Data Entries in Excel (5 Methods)