⚑Formatting

How to insert the current time in Google Sheets

Insert the current time into the selected cell as a static value.

Ctrl + Shift + ;

πŸ“‹ Step-by-Step Guide

  1. 1.Open Google Sheets in your browser.
  2. 2.Select the cell(s) you want to work with.
  3. 3.Press Ctrl + Shift + ; to insert the current time.

🎯 Shortcut Keys by Platform

PlatformShortcut
πŸ’» PC / Windows
Ctrl + Shift + ;
🍎 Mac
⌘ + Shift + ;
πŸ’» Chrome OS
Ctrl + Shift + ;

πŸ’‘ Pro Tips

  • You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
  • If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.

❓Frequently Asked Questions

πŸ“š Explore All Google Sheets Shortcuts

Discover 111 keyboard shortcuts to boost your productivity

View All Shortcuts ➜