There are many situations where you may need to enter the current date in a cell. Although you can type it manually, this can become tedious if you have to enter the date frequently.
Luckily, there is a keyboard shortcut using a semicolon (;) to instantly add the current date, and another shortcut to add the current time.
Watch the video below to see examples of these shortcuts in action.
Using these keyboard shortcuts can save you a lot of time and effort when adding this type of information to your Excel spreadsheets. Next up, we’ll show you a tip using the fill handle.
/en/excel-tips/a-faster-way-to-use-the-fill-handle/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.