Quickly Enter Current Date in Excel | How to get current date in Excel using shortcuts keys

preview_player
Показать описание
Quickly Enter Current Date and Time in Excel | How to get static & dynamic current date/time in Excel using keyboard shortcuts & functions!

learn how to quickly enter the current date and time into an Excel spreadsheet. You'll learn a couple of very helpful keyboard shortcuts that can save you lots of time and hassle Time. Press ctrl shift semicolon okay i held on for it i held on to it too long. But let's do it one more time ctrl shift semicolon. And then you'll get the current.

Do one of the following:
To insert the current date, press Ctrl+; (semi-colon).
To insert the current time, press Ctrl+Shift+; (semi-colon).
To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

#today
#date
#dateandtime
#exceltips
#time
#excelformula
#exceltips
#exceltipsandtricks
#shortcut
#livedateandtime
#
Рекомендации по теме