Excel kılavuzu

How to Insert Today's Date in Excel

Inserting a static date is useful for logging entries that should not change when the workbook is recalculated. This method uses a keyboard shortcut to save you time.

Bunun yerine yapay zekâ ile yap

Adım adım

1
Select the cell
Click on the cell where you want to insert the current date.
2
Use the shortcut
Press 'Ctrl' + ';' (semicolon) on your keyboard.
3
Confirm the entry
Press 'Enter' to finalize the date in the cell.

İpuçları

The date inserted this way is static and will not update automatically tomorrow.
If you need a date that updates automatically, use the =TODAY() function instead.

SSS

Does this shortcut work on Mac?

On Mac, use 'Command' + ';' instead.