Tech For The Rest Of Us

Hosted by Marlo Anderson

📅 Insert Today’s Date in One Press: Ctrl + ; in Google Sheets and Excel

Ctrl + semicolon inserts today's date in Google Sheets and Excel
Facebook
Twitter
LinkedIn
Pinterest
Pocket
WhatsApp

By Marlo Anderson – The Tech Ranch

If you keep an expense log, a timesheet or any running list in a spreadsheet, you type today’s date a lot. Skip it. Click a cell and press Ctrl + ; (semicolon), and today’s date drops right in.

The Shortcut

  • Ctrl + ; inserts today’s date in Google Sheets and Microsoft Excel
  • Mac: ⌘ + ; in Google Sheets, Control + ; in Excel for Mac

Why Not Use =TODAY()?

The =TODAY() formula always shows the current date, so it changes every day you open the file. Ctrl + ; types the date as a fixed value. It stays put, which is exactly what you want in a log.

Bonus Tip: Stamp the Time with Ctrl + Shift + ;

Press Ctrl + Shift + ; to insert the current time. On a Mac, use ⌘ + Shift + ; in Google Sheets or ⌘ + ; in Excel for Mac. It’s perfect for logs and timesheets.

More Keyboard Shortcuts, Explained

This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one. Short on time? Here’s the quick Short version.

Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.

Never miss any important news. Subscribe to our newsletter.

SUBSCRIBE TO PODCAST

Google Podcast

Subscribe
Copyright ©2026 The Tech Ranch
Secret Link