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.