Forum Discussion
Claudio Cantatore
Apr 27, 2017Copper Contributor
Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2013
Recently upgraded to Excel 2013 One of the most used (at least for me) shorcuts: 1) CTRL + ; to insert current date in a cell 2) CTRL + : to insert current time in a cell both do...
Jens Stolle
Apr 28, 2017Copper Contributor
Great links. And strangely the documentation seems to be false. It is CTRL+. (= STRG+.) in all versions in german. I teach Excel and in all versions it has been CTRL+. I also just tested CTRL+; in 2016 and that doesnt work in the german Version.
So still no idea what the correct Shortcut is in the language Version Raffaele uses (sounds italian to me?).
So still no idea what the correct Shortcut is in the language Version Raffaele uses (sounds italian to me?).
Claudio Cantatore
Apr 28, 2017Copper Contributor
Sorry for not having specified that. I'm Italian, I use a QWERTY Italian keyboard.
The shortcuts in ITA keyboard have always been CTRL+;/CTRL+:
And also the support.office.com help file in Italian says it :
- rbianchiDec 06, 2018Copper Contributor
It works if you enter in the excel field before pressing CTRL+;
Double click on the field and press CTRL+; and it works.
- SergeiBaklanDec 06, 2018MVP
Strange, it shall work without entering into cell edit mode