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?).
Anonymous
Apr 28, 2017Hi all,
I have Excel 2016 in German and I am using a german keyboard. For inputting the current date in an empty cell, I can use Ctrl+Dot as known from previous versions. So, in this case, it's for now an error in online help article regarding Ctrl+Semicolon.
For Excel 2016, there are some more errors in the Online Help Article for the German shortcuts, such as some Alt shortcuts, for example Alt+M which opens the Tell Me Box instead of the formulas tab. I already reported this to the MS localization team and they are going to check this.
Another problem in the online help article for the shortcuts (at least for German) is, that the shortcuts always refer to an English US keyboard. There is a note about this on the top of the article.
Therefore, the mentionned shortcuts (keystrokes) can lead to confusion and may be appear as incorrect. An example: for applying a date format, the German Online Article mentions that I can use Ctrl+Shift+#. This does not work, I have to use Ctrl+#. This is due to that # is on a german keyboard reachable without pressing the shift key. But from an en_US keyboard layouts' perspective, Ctrl+Shift+# is correct.
So, sometimes, it can be useful to try a mentionned shortcut from the online help in both combinations (Shifted/Unshifted) depending from the keyboard layout.
Best,
Mourad