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 don't work
the command does not return anything
the thing happens on 5 computers where Office 2013 has been installed, so it's probably not a thing having to do with virus/malware problems.
all other shortcuts seem to work though
Can you please help, I really use the two above frequently
Regards
Raffaele
- ksneufeldtCopper Contributor
None of the other replies I saw seems to be universally true.
I find that Excel is rather erratic on this topic. I work with a laptop originally set-up in German and English as my default language and depending on the tasks at hand may switch often, hardly or not at all.
I find that sometimes the shortcuts will work in German only, sometimes in Einglish only.
Usually related to the current language selected.
However, sometimes they do not work at all, until I restart Windows.
If I do, they then work in the language that I first used (possibly first used while saving a file) in Excel.
- Doha_muwafaqCopper ContributorI know I'm too late but for current date try ctrl + fn + ;
and for current time try ctrl + fn + :
worked for me- Yousef_ElsayedCopper Contributor
- Luci_RauCopper Contributor
I have tried all these suggestions but none work. ;(. I have Excel 365 and I change the language between ROU / ROS & ROU / RO & ENG / US & ENG / INTL and still not working.
If somebody can help me I'll be glad
- Jens StolleCopper Contributor
Hello Raffale,
I am using a german version, we have different Shortcuts for that (CTRL + . and CTRL + :). It works in 2013 as it worked before. Is your install in the same language as it was before? Maybe consult the help file to find out the correct combination?
Good Luck,
Jens
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.
- Dietmar5Copper Contributor
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.
Hi Raffaele,
Please check this https://social.technet.microsoft.com/Forums/lync/en-US/dccd77b7-8faa-4dbb-95be-28f438123301/insert-current-date-ctrl-not-working-probably-in-excel-2013?forum=officeitpro, perhaps something what discussed will help.
- osmanphusCopper Contributor
May I know if there any solution that in windows 10 + office 365 + Traditional Chinese keyboard? It seems only displaying ";" instead of ";".
- German_ChrisIron ContributorEnglish WIN 10 + Excel 365 English + QWERTZ german
CTRL (STRG in german) + SHIFT + ;
works fine