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 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

  • ksneufeldt's avatar
    ksneufeldt
    Copper Contributor

    Claudio Cantatore 

    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_muwafaq's avatar
    Doha_muwafaq
    Copper Contributor
    I know I'm too late but for current date try ctrl + fn + ;

    and for current time try ctrl + fn + :

    worked for me
  • Luci_Rau's avatar
    Luci_Rau
    Copper 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 Stolle's avatar
    Jens Stolle
    Copper 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

    • osmanphus's avatar
      osmanphus
      Copper Contributor

      SergeiBaklan 

       

      May I know if there any solution that in windows 10 + office 365 + Traditional Chinese keyboard? It seems only displaying ";"  instead of ";". 

      • German_Chris's avatar
        German_Chris
        Iron Contributor
        English WIN 10 + Excel 365 English + QWERTZ german
        CTRL (STRG in german) + SHIFT + ;
        works fine

Resources