Forum Discussion

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

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

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

Lost_in_the_wind
Copper Contributor
Feb 07, 2022
George-S thank you so much for your help! I got really frustrated trying to find a combination that actually works! Thanks once again for sharing it with everyone and good luck!