Excel shortcuts

How to Use the Today's Date Shortcut in Excel

If you're like most people, you probably have to use Excel on a daily basis. And if you're like most people, you probably find yourself having to enter the current date into a cell quite often. Well, there's a handy shortcut that can save you a lot of time.

To enter the current date into a cell, simply press Ctrl+;. That's it! The current date will be entered into the cell.

This shortcut is particularly handy if you're keeping track of something that needs to be updated on a daily basis, such as a to-do list. Simply enter the date once, and then every time you open the file, the date will be updated to today's date.

If you need to enter the current date and time, the shortcut is slightly different. Press Ctrl+Shift+; to enter the current date and time into a cell.

This shortcut is also useful if you're keeping track of something that needs to be updated on a daily basis. For example, you could use it to track when a task was last updated. Simply enter the date and time once, and then every time you open the file, the date and time will be updated to the current date and time.

There you have it! A quick and easy way to enter the current date or date and time into an Excel cell. Give it a try the next time you need to enter the date or date and time into a cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.