logo

Shortcut to Enter Current Date and Time in Excel 📂Programing

Shortcut to Enter Current Date and Time in Excel

Overview

Introduces keyboard shortcuts that insert the current date and time directly into a cell in Excel. Particularly useful when you need to manually record logs.

Guide

  • ctrl;: Inserts the current date into the selected cell.
  • ctrl:: Inserts the current time into the selected cell.

Note that ctrl: is equivalent to ctrlshift;.

Notepad tip

As a side note, in Notepad, pressing the F5 key inserts the current date and time.