Insert Current Date in Excel
This shortcut allows you to quickly insert the current date into a selected cell without typing it manually. Very useful for date tracking and logs.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + ; | Cmd + ; |
What Does This Shortcut Do?
Pressing this shortcut inserts the current system date into the active cell. The value is static and does not update automatically.
How to Use the Shortcut
- Select the cell where you want the current date
- Press Ctrl + ; (Windows) or Cmd + ; (Mac)
- The current date will appear in the selected cell
Tips & Best Practices
- Use in logs, invoices, or forms where date stamping is needed
- Combine with Ctrl + Shift + ; to insert current time
- Format the cell as needed for different date formats
FAQ
- Q: Will the date update automatically the next day?
- No, this inserts a static date. Use
=TODAY()if you want a dynamic date. - Q: Can I insert dates in multiple cells at once?
- Yes, select multiple cells and press Ctrl + ; to fill them all with the current date.