In Excel, what is the keyboard shortcut to insert the current date in a cell?

a) Ctrl+D

b) Ctrl+T

c) Ctrl+; (semi-colon)

d) Ctrl+:

Show Answer

c) Ctrl+; (semi-colon)

In Microsoft Excel, you can quickly insert the current date in a cell by using the keyboard shortcut CTRL + ;

(semi-colon). Here’s how you can do it:

  1. Select the cell where you want to insert the current date.
  2. Press CTRL + ; on your keyboard.
  3. The current date will be entered into the selected cell in the default date format.

Please note that the current date is static when inserted using this keyboard shortcut. If you want the date to update automatically to the current date every time you open the spreadsheet, you can use a formula like =Today() or =Now() in the cell. These functions will update with the current date or time whenever the workbook is recalculated or opened.