TToolardo
← Useful Tips
Microsoft ExcelExcel

Ctrl + ;: Insert today’s date

Use Ctrl + ; to insert today’s date. Useful for quick spreadsheet editing and formula debugging.

Ctrl + ;

Why it helps

Use Ctrl + ; to insert today’s date. Useful for quick spreadsheet editing and formula debugging.

How to use it

  1. Open the relevant app or terminal.
  2. Use the shortcut or command above in the relevant context.
  3. Check the result; for commands that change data, test on a small example first.
People also search for
Ctrl + ;: Insert today’s dateCtrl + ;insert today’s datehow to insert today’s dateMicrosoft Excel insert today’s date

Related tips

Microsoft ExcelCtrl + Shift + ;

Ctrl + Shift + ;: Insert the current time

Use Ctrl + Shift + ; to insert the current time. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelCtrl + `

Ctrl + `: Toggle formula view

Use Ctrl + ` to toggle formula view. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelF4 while editing a formula

F4 while editing a formula: Cycle absolute and relative cell references

Use F4 while editing a formula to cycle absolute and relative cell references. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelCtrl + T

Ctrl + T: Turn a data range into an Excel Table

Use Ctrl + T to turn a data range into an Excel Table. Useful for quick spreadsheet editing and formula debugging.