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?). Reply Show More Show Mo...
In this tutorial, you will learn how to quickly insert current time in Excel using a shortcut, formula, or VBA macro. Also, we'll look at how to convert timestamp to date and get hours, minutes or seconds from a timestamp. There are a number of ways to insert time into Excel works...
Retrieve date and time by shortcut key Here are some shortcuts for inserting current date and time in Windows and Mac systems. In Windows systems To insert current date, press Ctrl + ; To insert current time, press Shift + Ctrl +; To insert current date and current time,...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will...
1] Use the keyboard shortcut These two keyboard shortcuts will let you insert the current date and time in any cell of your spreadsheet. It doesn’t matter if you are using Google Sheets or Microsoft Excel; you can use these hotkeys. ...
This shortcut is especially helpful when you're working with larger data sets, but only need to select a specific piece of it. 2. Quickly open, close, or create a workbook. Need to open, close, or create a workbook on the fly? The following keyboard shortcuts will enable...
To enter the exact time, double click on a cell andpress CTRL + SHIFT + ; To get the current date, justpress CTRL + ; You can also enter both the values in the same cell by entering either the date or time first, then applying the other shortcut after hitting the space bar once....
Excel Date and Time Shortcuts 'Good to Know' Stuff about Excel Date and Time More Excel Date and Time Tips Regional Settings When reading this post keep in mind that my regional settings format dates as dd/mm/yyyy and so the screenshots throughout this post are in this format. ...
#8 Insert Current Date and Time This keyboard shortcut can be used toquickly insert timestampsin cells. To insert the current date, use the keyboard shortcut: CONTROL ; To insert the current time, use the keyboard shortcut: CONTROL SHIFT ; ...
This is a list of all the shortcut keys related to dates and times. Ctrl + ; Enters the current date/todays date into the active cell and applies the format "dd/mm/yyyy". Ctrl + Shift + ; (:) Enters the current time into the active cell and applies the format "hh:mm". Ctrl ...