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
Luci_Rau's avatar
Luci_Rau
Copper Contributor
Apr 20, 2020

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

  • Dietmar5's avatar
    Dietmar5
    Copper Contributor
    Apr 22, 2020

    Luci_Rau 

    Try Ctrl + .

    For whatever reason they have different shortcuts in the various languages. 

     

    • Luci_Rau's avatar
      Luci_Rau
      Copper Contributor
      Apr 22, 2020

      Dietmar5 

      I try it, doesn't work. 😞

      • Dietmar5's avatar
        Dietmar5
        Copper Contributor
        Apr 22, 2020

        Luci_Rau 

        Hm. I have installed English, Ukrainian, German language pack. It works in all of the three with Ctrl + .

        You know you have to press those two keys at the same time, right?

        I press Ctrl, hold it and then press in addition  the Dott . Sometimes computer do not do what they are supposed to do for some silly little reason.

        It changed from Ctrl + : after an update for whatever was the innitiative.

        Maybe try to reinstall the language packs.

        I have also the Microsoft Keyboard Layout Creator 1.4 in use. Changed some letter around on the keyboard. Quite helpful tool.

        Hope some of these ideas help,the shortcut is quite helpful, use it often.

        Good luck in trying these.

Resources