Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2021

Question

1.  CTRL + ;    to insert current date in a cell
2.  CTRL + :    to insert current time in a cell

 

both don't work

 

the command does not return anything.

Answer 1

Hello Omar Cristian Martinez ,

Thank you for reaching out on the Microsoft Q&A .

The old keyboard shortcuts for date and time (Ctrl+; and Ctrl+:) aren't available in Excel 2021 anymore. No worries! You can still insert them easily. Just type "=TODAY()" for the current date or "=NOW()" for the current time. These formulas will automatically update whenever you open the spreadsheet.

I hope this helps! If you have any further questions, feel free to ask.

If the information is useful, please accept the answer and upvote it to assist other community members.

Answer 2

Hi @Omar Cristian Martinez

I suggest you click: File > Account > Product Information, check the Office version name and version number in Excel.

• You may click "Update Now" in "Update Options", ensure Office is updated to the latest one.
• What the input language are you using? Please switch another input language for a test.
• To insert to current time in a cell, please try to press "Ctrl", "Shift" and ";" (On some keyboards, the ";" and ":" are on one key).
• Besides, it's recommended to test theses shortcuts in Excel Safe Mode. You can press and hold on Ctrl key, click or double-click Excel icon, until Excel asks do you want to start it in safe mode, then please release Ctrl key and click "Yes". Safe Mode will help us troubleshoot the add-ins and startup items.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---