locked
Insert Current date - (Ctrl+;) not working probably in Excel 2013? RRS feed

  • Question

  • i have question/problem ? i used to Press CTRL + ; to enter date quickly in excel 2010 , 2007 when i tried to use it in excel 2013 , it doesn't work despite that i read in Microsoft official website that it works ? Could you help me to fix it ?

    Version : Microsoft Office ProPlus 2013 SP1 VL x64 en-US Apr2014

    Sunday, May 18, 2014 9:28 AM

Answers

  • Hi,

    Does the issue occur only in the special keyboard shortcut key(CTRL + ;) or the other shortcut keys? When does this issue occur?  Just installed Excel 2013 or after using a period of time? Do you install some programs recently?

    I recommend you may try the following methods to check if they are helpful:

    a) Start Excel in safe mode (Press Win+R>Type Excel.exe /Safe), if it works well, please disable and check the add-ins one by one.

    b) Repair Office in Control Panel > Programs > Programs and Features

    c) Use Application.OnKey Method

    http://msdn.microsoft.com/en-us/library/office/ff197461(v=office.15).aspx

    d) Check if the keyboard shortcut key is disabled via Group Policy

    http://technet.microsoft.com/en-us/library/cc179143(v=office.15).aspx

    If the issue still exists, we'd better use Process monitor to detect which process/thread block the keyboard shortcut key(CTRL + ;).

    Regards,

    George Zhao
    TechNet Community Support



    • Marked as answer by George123345 Tuesday, May 27, 2014 5:53 AM
    Monday, May 19, 2014 7:46 AM

All replies

  • Hi,

    Does the issue occur only in the special keyboard shortcut key(CTRL + ;) or the other shortcut keys? When does this issue occur?  Just installed Excel 2013 or after using a period of time? Do you install some programs recently?

    I recommend you may try the following methods to check if they are helpful:

    a) Start Excel in safe mode (Press Win+R>Type Excel.exe /Safe), if it works well, please disable and check the add-ins one by one.

    b) Repair Office in Control Panel > Programs > Programs and Features

    c) Use Application.OnKey Method

    http://msdn.microsoft.com/en-us/library/office/ff197461(v=office.15).aspx

    d) Check if the keyboard shortcut key is disabled via Group Policy

    http://technet.microsoft.com/en-us/library/cc179143(v=office.15).aspx

    If the issue still exists, we'd better use Process monitor to detect which process/thread block the keyboard shortcut key(CTRL + ;).

    Regards,

    George Zhao
    TechNet Community Support



    • Marked as answer by George123345 Tuesday, May 27, 2014 5:53 AM
    Monday, May 19, 2014 7:46 AM
  • after repaired office it's working now 

    thanks a lot 

    Friday, May 30, 2014 12:33 AM
  • I´ve tried all solutions above, none working. I have Excel 2013 Business 15.0.4787.1002. I work under slovak QWERTY keyboard. It´s same shortcuts - CTRL + ; and CTRL + SHIFT + ; .

    Others shortcuts works fine.

    Can you help?



    • Proposed as answer by Vlado S Monday, February 1, 2016 12:35 PM
    • Edited by Vlado S Monday, February 1, 2016 12:35 PM
    • Unproposed as answer by Vlado S Monday, February 1, 2016 12:35 PM
    Monday, February 1, 2016 12:34 PM
  • Had it on 365

    Found out that it is the semicolon if you use English as language and it is the dot when you use German as the language.

    Friday, August 30, 2019 2:32 PM
  • Using 2007 MICROSOFT OFFICE SYSTEM but window is recently updated from 2007 to 2013, yet the 2007 MICROSOFT OFFICE SYSTEM is still the same.

    I cannot ctrl+; and it's not unreacting but slightly twinkling when I shortcut, how can I solve the problem?

    Tuesday, December 17, 2019 4:13 AM