Excel - Insert current date or time
April 2018
Microsoft Excel is one of the best office software tools, for performing tasks varying from very simple to complex, depending on your requirements. Excel has some built in shortcuts which can assist the user in doing simple tasks like generating the current time, date, day, year, etc.The shortcuts for the current time, date, etc. can be found in Microsoft Excel help, by typing in the relevant query. Often, these shortcuts are inserted into the hardware of the computer through a combination of keys like Ctrl, Shift and some special characters. This feature provides a handy way of generating timestamps and keeping track of any changes that require future references.
To insert the current date:
To insert the current time:
To insert the current date:
- Select the cell you want the date to appear in
- Press CTRL + ;
To insert the current time:
- Select the cell you want the time to appear in
- Press CTRL + SHIFT + ;
Related
- Excel - Insert current date or time
- Notepad - Quickly insert actual date and time » How-To - Windows
- Excel - Concatenate the date with time » How-To - Excel
- Java -Retrieve current date and time » How-To - Languages
- Enter current date and time with SHORTEST CUT » Forum - Excel
- Excel - Enter current time in a cell by clicking it » How-To - Excel