Forum Discussion
Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2013
Hi Jens,
Yes, these shortcuts are almost from VisiCalc time and shall work on all available versions of Excel, at least for standard US layout.
Anyway, here are links on shortcuts
If to check another language just select it from very bottom of the page, e.g. German
From second one strange thing, for versions 2007, 2010
STRG+; Gibt das aktuelle Datum ein.
for 2013
STRG+. Gibt das aktuelle Datum ein.
for 2016 it is back
Eingeben des aktuellen Datums STRG+SEMIKOLON (;)
If i understood German correctly, know only few words on it.
In 365 it was until late ( CTRL + ; ) -- Now thanks your post and after some while I find it on ( CTRL + . ) I have but no clue what benefit this change shortcuts around has for an Microsoft employee, for Millions of users searching what it might be today it is a huge waste of time.
Add, some kind of sorry, found out most probably why:
It was ( CTRL + ; ) on 365 with English Keyboard and English Excel.
Now it is ( CTRL + . ) on 365 with English Keyboard but German Excel.
That makes a difference, for what reason whatsoever we need sometimes . and sometimes ;
It would help those users which travel lots and far and use different types of IT like I do if Microsoft could decide that they like the most. The dot or the semicolon. We are already a global community, thanks also to Microsoft.
- For Russian Windows users (even if you use it English interface and English Excel): CTRL+; (on Ж button) is not works too. You're need to use it CTRL+SHIFT+4
Для тех у кого русская виндоуз, чтобы вставить текущую дату в ячейку необходимо нажать CTRL+SHIFT+4George-S thank you so much for your help! I got really frustrated trying to find a combination that actually works! Thanks once again for sharing it with everyone and good luck!
