Forum Discussion

Claudio Cantatore's avatar
Claudio Cantatore
Copper Contributor
Apr 27, 2017

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...
excel
Jens Stolle's avatar
Jens Stolle
Copper Contributor
Apr 27, 2017

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 27, 2017

    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

    https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f#ID0EABDAAA=2013

     

    If to check another language just select it from very bottom of the page, e.g. German

    https://support.office.com/de-de/article/Excel-Tastenkombinationen-und-Funktionstasten-f%c3%bcr-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f?omkt=de-DE&ui=de-DE&rs=de-DE&ad=DE

     

    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. 

     

    • Dietmar5's avatar
      Dietmar5
      Copper Contributor
      Aug 30, 2019

      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.

      • George-S's avatar
        George-S
        Copper Contributor
        Sep 20, 2019
        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+4
    • Jens Stolle's avatar
      Jens Stolle
      Copper Contributor
      Apr 28, 2017
      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?).
      • Claudio Cantatore's avatar
        Claudio Cantatore
        Copper Contributor
        Apr 28, 2017

        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 :

         

        https://support.office.com/it-it/article/Scelte-rapide-da-tastiera-e-tasti-funzione-di-Excel-per-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f?omkt=it-IT&ui=it-IT&rs=it-IT&ad=IT#ID0EAAEAAA=2013

         

Resources