Quick way to insert the current date and time in Excel
You might be working on a project, carrying out an audit, or — as shown in the video — inspecting a hotel room.
Date and timestamps have many uses, but did you know about an easy way to insert them?
Instead of typing them manually, use the following keyboard shortcuts:
➤ Insert current date: Ctrl + ;
➤ Insert current time: Ctrl + Shift + ;
These can also be inserted in the same cell. Just separate each with a space.
#excel #microsoftexcel #exceltips #globalexcelsummit
The Global Excel Summit is the world's largest virtual gathering of Microsoft Excel users and experts.
Learn more at https://globalexcelsummit.com/.
Find us on:
👔 LinkedIn: / global-excel-summit
🐤 Twitter: / excelsummit
🟦 Facebook: / globalexcelsummit
📸 Instagram: / globalexcelsummit
Get ready to Excel Beyond Expectation.