How to Create a Field That Will Show the Current Time and Date in Microsoft Excel

Sometimes, when working in Microsoft Excel, we need a field that will display the current time or date. This is quite easy to do and will only take a few clicks.

Watch our video tutorial where we show you how to create a field that will show the current time and date in Microsoft Excel, using Windows 10.

Video Transcript:

1. How to Create a Field That Will Show the Current Time and Date in Microsoft Excel
2. First, we will create a field that will display the date
3. Open the drop-down and select the date format you want to use
4. Click on the field where you want to display the current date and type =now() and press Enter on your keyboard
5. To display the current time, open the drop-down and select Time
6. Click on the field where you want to display the current time and type =now() and press Enter on your keyboard

Rate:

(No Ratings Yet)

Loading...