Excel shortcuts

5 Quick Date Shortcuts in Excel

If you work with dates in Excel, you know how frustrating it can be to try to remember all the different date formats. There are so many different ways to enter dates into Excel, and it can be hard to keep track of them all. But there are a few quick shortcuts that can help you quickly enter dates into Excel. Here are 5 of them:

  1. To enter the current date, simply press Ctrl+;. This shortcut will insert the current date into the cell you have selected.
  2. To enter the current time, press Ctrl+Shift+;. This shortcut will insert the current time into the cell you have selected.
  3. To enter the date and time together, press Ctrl+Shift+:. This shortcut will insert the current date and time into the cell you have selected.
  4. To enter a specific date, press Ctrl+Shift+#. This shortcut will insert the date you have selected into the cell you have selected. For example, if you want to enter the date 12/12/12, you would press Ctrl+Shift+12.
  5. To enter a specific time, press Ctrl+Shift+@. This shortcut will insert the time you have selected into the cell you have selected. For example, if you want to enter the time 12:00:00, you would press Ctrl+Shift+12.

These shortcuts can save you a lot of time when you're working with dates in Excel. Give them a try the next time you're working with dates in Excel and see how much easier they make your life!

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.