Insert Today's Date In Excel With A Handy Keyboard Shortcut

A handy addition to our favourite Excel keyboard shortcuts: typing Control-; will insert the current date. If you want the current time, type Control-Shift-;.

As Helen Bradley's Project Woman site notes, Excel has functions for inserting the current date or time (=TODAY() and =NOW()), but those values regularly update whenever you recalculate the worksheet. The keyboard shortcuts are a nifty way of time or date-stamping specific cells.

Trevor’s Quick Excel Tip – Date and Time [Project Woman]


Comments

    I found this a month or so back when I needed it for a particular task at work. I can't see it being useful or memorable for most uses, but in my case it was a lifesaver.

    is that a similar one for use in word?

Join the discussion!