Home

Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-65434%22%20slang%3D%22en-US%22%3EShortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65434%22%20slang%3D%22en-US%22%3E%3CP%3ERecently%20upgraded%20to%20Excel%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20the%20most%20used%20(at%20least%20for%20me)%20shorcuts%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20%26nbsp%3B%3CSTRONG%3ECTRL%20%2B%20%3B%3C%2FSTRONG%3E%26nbsp%3B%20%26nbsp%3Bto%20insert%20current%20date%20in%20a%20cell%3C%2FP%3E%3CP%3E2)%20%26nbsp%3B%3CSTRONG%3ECTRL%20%2B%20%3A%3C%2FSTRONG%3E%26nbsp%3B%20%26nbsp%3B%20to%20insert%20current%20time%20in%20a%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eboth%20don't%20work%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20command%20does%20not%20return%20anything%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20thing%20happens%20on%205%20computers%20where%20Office%202013%20has%20been%20installed%2C%20so%20it's%20probably%20not%20a%20thing%20having%20to%20do%20with%20virus%2Fmalware%20problems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eall%20other%20shortcuts%20seem%20to%20work%20though%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%2C%20I%20really%20use%20the%20two%20above%20frequently%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ERaffaele%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-65434%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-297111%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-297111%22%20slang%3D%22en-US%22%3E%3CP%3EStrange%2C%20it%20shall%20work%20without%20entering%20into%20cell%20edit%20mode%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-296915%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-296915%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20works%20if%20you%20enter%20in%20the%20excel%20field%20before%20pressing%20CTRL%2B%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDouble%20click%20on%20the%20field%20and%20press%20CTRL%2B%3B%20and%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65798%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65798%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20for%20not%20having%20specified%20that.%20I'm%20Italian%2C%20I%20use%20a%20QWERTY%20Italian%20keyboard.%3C%2FP%3E%3CP%3EThe%20shortcuts%20in%20ITA%20keyboard%20have%20always%20been%20CTRL%2B%3B%2FCTRL%2B%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20also%20the%20support.office.com%20help%20file%20in%20Italian%20says%20it%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2FScelte-rapide-da-tastiera-e-tasti-funzione-di-Excel-per-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%3Fomkt%3Dit-IT%26amp%3Bui%3Dit-IT%26amp%3Brs%3Dit-IT%26amp%3Bad%3DIT%23ID0EAAEAAA%3D2013%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2FScelte-rapide-da-tastiera-e-tasti-funzione-di-Excel-per-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%3Fomkt%3Dit-IT%26amp%3Bui%3Dit-IT%26amp%3Brs%3Dit-IT%26amp%3Bad%3DIT%23ID0EAAEAAA%3D2013%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65721%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65721%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Excel%202016%20in%20German%20and%20I%20am%20using%20a%20german%20keyboard.%20For%20inputting%20the%20current%20date%20in%20an%20empty%20cell%2C%20I%20can%20use%20Ctrl%2BDot%20as%20known%20from%20previous%20versions.%20So%2C%20in%20this%20case%2C%20it's%20for%20now%20an%20error%20in%20online%20help%20article%20regarding%20Ctrl%2BSemicolon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Excel%202016%2C%20there%20are%20some%20more%20errors%20in%20the%20Online%20Help%20Article%20for%20the%20German%20shortcuts%2C%20such%20as%20some%20Alt%20shortcuts%2C%20for%20example%20Alt%2BM%20which%20opens%20the%20Tell%20Me%20Box%20instead%20of%20the%20formulas%20tab.%20I%20already%20reported%20this%20to%20the%20MS%20localization%20team%20and%20they%20are%20going%20to%20check%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20problem%20in%20the%20online%20help%20article%20for%20the%20shortcuts%26nbsp%3B(at%20least%20for%20German)%20is%2C%20that%20the%20shortcuts%20always%20refer%20to%20an%20English%20US%20keyboard.%20There%20is%20a%20note%20about%20this%20on%20the%20top%20of%20the%20article.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%2C%20the%20mentionned%20shortcuts%20(keystrokes)%20can%20lead%20to%20confusion%20and%20may%20be%20appear%20as%20incorrect.%20An%20example%3A%26nbsp%3Bfor%26nbsp%3B%3CSPAN%3Eapplying%20a%20date%20format%2C%20the%20German%20Online%20Article%20mentions%20that%20I%20can%20use%20Ctrl%2BShift%2B%23.%20This%20does%20not%20work%2C%20I%20have%20to%20use%20Ctrl%2B%23.%20This%20is%20due%20to%20that%20%23%20is%20on%20a%20german%20keyboard%20reachable%20%3CEM%3Ewithout%3C%2FEM%3Epressing%20the%20shift%20key.%20But%20from%20an%20%3CEM%3Een_US%20keyboard%20layouts'%20perspective%3C%2FEM%3E%2C%20Ctrl%2BShift%2B%23%20is%20correct.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20840px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F13903i2CB9E8AF0DEE5753%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222017.04.12-11.07.54.png%22%20title%3D%222017.04.12-11.07.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20sometimes%2C%20it%20can%20be%20useful%20to%20try%20a%20mentionned%20shortcut%20from%20the%20online%20help%20in%20both%20combinations%20(Shifted%2FUnshifted)%20depending%20from%20the%20keyboard%20layout.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EMourad%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65706%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65706%22%20slang%3D%22en-US%22%3EGreat%20links.%20And%20strangely%20the%20documentation%20seems%20to%20be%20false.%20It%20is%20CTRL%2B.%20(%3D%20STRG%2B.)%20in%20all%20versions%20in%20german.%20I%20teach%20Excel%20and%20in%20all%20versions%20it%20has%20been%20CTRL%2B.%20I%20also%20just%20tested%20CTRL%2B%3B%20in%202016%20and%20that%20doesnt%20work%20in%20the%20german%20Version.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20still%20no%20idea%20what%20the%20correct%20Shortcut%20is%20in%20the%20language%20Version%20Raffaele%20uses%20(sounds%20italian%20to%20me%3F).%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65665%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65665%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jens%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20these%20shortcuts%26nbsp%3Bare%20almost%20from%20VisiCalc%20time%20and%20shall%20work%20on%20all%20available%26nbsp%3Bversions%20of%20Excel%2C%20at%20least%20for%20standard%20US%20layout.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20here%20are%20links%20on%20shortcuts%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%23ID0EABDAAA%3D2013%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%23ID0EABDAAA%3D2013%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20to%20check%20another%20language%20just%20select%20it%20from%20very%20bottom%20of%20the%20page%2C%20e.g.%20German%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fde-de%2Farticle%2FExcel-Tastenkombinationen-und-Funktionstasten-f%25c3%25bcr-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%3Fomkt%3Dde-DE%26amp%3Bui%3Dde-DE%26amp%3Brs%3Dde-DE%26amp%3Bad%3DDE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fde-de%2Farticle%2FExcel-Tastenkombinationen-und-Funktionstasten-f%25c3%25bcr-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f%3Fomkt%3Dde-DE%26amp%3Bui%3Dde-DE%26amp%3Brs%3Dde-DE%26amp%3Bad%3DDE%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20second%20one%20strange%20thing%2C%20for%20versions%202007%2C%202010%3C%2FP%3E%3CPRE%3ESTRG%2B%3B%0AGibt%20das%20aktuelle%20Datum%20ein.%3C%2FPRE%3E%3CP%3Efor%202013%3C%2FP%3E%3CPRE%3ESTRG%2B.%0AGibt%20das%20aktuelle%20Datum%20ein.%3C%2FPRE%3E%3CP%3Efor%202016%20it%20is%20back%3C%2FP%3E%3CPRE%3EEingeben%20des%20aktuellen%20Datums%20%0ASTRG%2BSEMIKOLON%20(%3B)%3C%2FPRE%3E%3CP%3EIf%20i%20understood%20German%20correctly%2C%20know%20only%20few%20words%20on%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65646%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20%20CTRL%20%2B%20%3B%20%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65646%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Raffale%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20a%20german%20version%2C%20we%20have%20different%20Shortcuts%20for%20that%20(CTRL%20%2B%20.%20and%20CTRL%20%2B%20%3A).%20It%20works%20in%202013%20as%20it%20worked%20before.%20Is%20your%20install%20in%20the%20same%20language%20as%20it%20was%20before%3F%20Maybe%20consult%20the%20help%20file%20to%20find%20out%20the%20correct%20combination%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20Luck%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJens%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65626%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20%20CTRL%20%2B%20%3B%20%20)%20don't%20work%20in%20EXCEL%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65626%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Raffaele%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Flync%2Fen-US%2Fdccd77b7-8faa-4dbb-95be-28f438123301%2Finsert-current-date-ctrl-not-working-probably-in-excel-2013%3Fforum%3Dofficeitpro%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Flync%2Fen-US%2Fdccd77b7-8faa-4dbb-95be-28f438123301%2Finsert-current-date-ctrl-not-working-probably-in-excel-2013%3Fforum%3Dofficeitpro%3C%2FA%3E%2C%20perhaps%20something%20what%20discussed%20will%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831311%22%20slang%3D%22en-US%22%3ERe%3A%20Shortcuts%20to%20insert%20current%20date%20and%20time%20(%20CTRL%20%2B%20%3B%20)%20don't%20work%20in%20EXCEL%202013%20and%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831311%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20365%20it%20was%20until%20late%20(%20CTRL%20%2B%20%3B%20)%26nbsp%3B%20--%26nbsp%3B%20Now%20thanks%20your%20post%20and%20after%20some%20while%20I%20find%20it%20on%20(%20%3CFONT%3ECTRL%20%2B%20.%20)%20%3C%2FFONT%3E%3CFONT%3EI%20have%20but%20no%20clue%20what%20benefit%20this%20change%20shortcuts%20around%20has%20for%20an%20Microsoft%20employee%2C%20for%20Millions%20of%20users%20searching%20what%20it%20might%20be%20today%20it%20is%20a%20huge%20waste%20of%20time.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EAdd%2C%20some%20kind%20of%20sorry%2C%20found%20out%20most%20probably%20why%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EIt%20was%26nbsp%3B(%20CTRL%20%2B%20%3B%20)%20on%20365%20with%20English%20Keyboard%20and%20English%20Excel.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3ENow%20it%20is%26nbsp%3B(%20CTRL%20%2B%20.%20)%20on%20365%20with%20English%20Keyboard%20but%20German%20Excel.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EThat%20makes%20a%20difference%2C%20for%20what%20reason%20whatsoever%20we%20need%20sometimes%20.%20and%20sometimes%20%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EIt%20would%20help%20those%20users%20which%20travel%20lots%20and%20far%20and%20use%20different%20types%20of%20IT%20like%20I%20do%20if%20Microsoft%20could%20decide%20that%20they%20like%20the%20most.%20The%20dot%20or%20the%20semicolon.%20We%20are%20already%20a%20global%20community%2C%20thanks%20also%20to%20Microsoft.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Claudio Cantatore
New Contributor

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

9 Replies

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

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

 

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

 

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. 

 

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?).

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

 

2017.04.12-11.07.54.png

 

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

 

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

 

It works if you enter in the excel field before pressing CTRL+;

 

Double click on the field and press CTRL+; and it works.

 

Strange, it shall work without entering into cell edit mode

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.

Related Conversations