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.

About Arsalan Mukhtar's content is in good hands with Arsalan Mukhtar! He works with a great team to write interesting and helpful articles. If you need the latest news, advice, or cool stories, Arsalan Mukhtar's got you covered! Check out the website and see what they can do for you. Now-a-days it is very difficult to find the quality data on internet because lots of low-quality websites are now designed that contain very useless data on them.