Insert TIMESTAMP in Google Sheets

  • Reading time:2 mins read
  • Post category:Date-Time
  • Post comments:0 Comments

If your are looking for a way to insert TIMESTAMP or date/time to a cell then this tutorial is for you. We’ll discuss multiple ways of inserting timestamp as well as the associated caveats.

Using Keyboard Shortcuts

Use the below Keyboard Shortcuts to insert Date, Time and Date Time into Cells. Simply Select the cells where you need to insert and execute these shortcuts.

Date: CONTROL + :
TimeStamp: CONTROL + ALT + SHIFT + :

Just executed it all at once and it works pretty flawlessly

Date Time Shortcuts to insert Timestamp in Google Sheets


  1. The above method inserts static Date Time Values, i.e. they wont change if values in other cells changes.
  2. The above methods is not scalable and will have to be applied one cell at a time

Using Google Sheet Functions

There are multiple Functions provided by Google sheet to help insert date time values. Keep in mind that these functions are volatile, i.e. they will be recalculated and updated with any change made to the spreadsheet.

TODAY() Returns the current Date. NOW() returns the current TimeStamp.

Date Time Functions to insert Timestamp in Google Sheets

Now, lets have the test of volatility. I am making changes to a random cell and we can see the time getting updated. Funny thing is if i open this sheet tomorrow, the date cell, B2 will get updated as well.

Volatile Function Example - Google Sheets

In case you want to avoid this behavior then simply copy the cells(B2:B3 in out case) and paste them back as values. This action will rid the cell of any formulas and just preserve a static output.

Paste Special as Values in Google Sheets

Using Google App Script

All the methods discussed till now have limilations of their own. The shortcut method is just not scalable and the formula method though partially scalable has volatility issues.

Fortunately, we can use google app script to overcome both the challenges and make the entire process truly automated and scalable.

You can follow the below links where this solution is mentioned in greater detail.


That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.


I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply