To insert a fixed timestamp in Google Sheets, enter =NOW(), copy the cell, then choose Edit > Paste special > Values only; this replaces the updating formula with a fixed date and time. For a timestamp that updates automatically, leave =NOW() in the cell. The right choice depends on whether you need to record when something happened or simply display the current time.
What a timestamp means in Google Sheets
A timestamp usually means a date and time stored together, such as 11/3/2026 9:42 AM. In a tracking sheet, it might record when a request arrived, when a task was completed, or when a row was last updated. The key distinction is whether the value should stay put or change as the sheet recalculates.
A fixed timestamp preserves the time at which you entered or captured it. A live timestamp reflects the current time and can update later. These behave differently even if they look identical in a cell. Formatting changes how a date or time appears; it does not make a changing formula into a fixed record.
- Use a fixed timestamp for records such as submissions, check-ins, and completed tasks.
- Use a live timestamp when you want a dashboard to show the current date and time.
- Use automation when each qualifying edit should receive a timestamp without someone entering it manually.
Insert a fixed date or time with a shortcut
Google Sheets in a web browser has keyboard shortcuts for inserting the current date or the current time as a value. Select a cell, then use the appropriate shortcut. The inserted value does not keep recalculating like a formula.
- On Windows or ChromeOS, press Ctrl+; to insert the current date.
- On Windows or ChromeOS, press Ctrl+Shift+; to insert the current time.
- On a Mac, use Command+; for the date and Command+Shift+; for the time.
These shortcuts insert a date or time separately, not necessarily a complete combined timestamp in one action. If you need both in one cell, the formula-and-freeze method below is a straightforward option. Shortcuts can vary with keyboard layout, browser, and operating-system settings; if one does not work, use the formula method or check Google Sheets’ keyboard shortcut help.
Make a fixed timestamp with NOW
The NOW() function returns the current date and time. To capture its result as a permanent value, enter =NOW() in a cell and press Enter. Copy that cell, then choose Edit > Paste special > Values only. The pasted result is a value rather than a formula, so it will not change when the sheet recalculates.
For example, suppose you receive a support request at 9:42 AM. Enter the formula in the request’s timestamp cell, copy it, and paste values only into that cell. The resulting date and time record the capture moment; entering =NOW() and leaving it in place would instead show a time that can change later.
Depending on the cell’s number format, the result might initially display only a date or a serial-looking number. Set the cell to a date-and-time format to make it readable. Freezing a value also means it will not adjust if you later change the sheet’s time zone or decide that the original entry time was incorrect; edit it deliberately if a correction is needed.
Show a live timestamp with NOW
Enter =NOW() in a cell when you want the current date and time rather than a historical record. Google Sheets recalculates this volatile function when the spreadsheet recalculates. It is therefore useful for a “last refreshed” display or a simple current-time indicator, but it is not a dependable way to preserve when a particular row was first entered.
How often a volatile formula recalculates can depend on the spreadsheet’s calculation settings and activity. To review those settings, open File > Settings and look under the calculation options. Avoid treating a live formula as an audit trail: another edit or recalculation can change its displayed result. TODAY() is the related function for the current date without a time, but it is also a changing formula, not a fixed date stamp.
Automatically timestamp edits with Apps Script
If a timestamp should be written whenever someone fills in a particular column, a small Apps Script can do it. For example, the script below writes a fixed time in column B when a user edits one cell in column A, starting on row 2. In the spreadsheet, open Extensions > Apps Script, add the code to the project, and save it.
function onEdit(e) {
const range = e.range;
// Timestamp a single edited cell in column A, from row 2 onward.
if (range.getColumn() !== 1 || range.getNumColumns() !== 1) return;
if (range.getRow() < 2 || range.getNumRows() !== 1) return;
if (e.value === undefined || e.value === "") return;
range.offset(0, 1).setValue(new Date());
}
This is a simple onEdit trigger: it runs when a user edits the sheet, so you do not need to run the function manually. It is intentionally limited to single-cell edits in column A. A paste covering multiple rows will not be timestamped by this example, and editing or clearing a value in column B does not make the script run. Clearing the source cell in column A also leaves the existing timestamp in place.
For a real workflow, adjust the watched and timestamp columns, test on a copy, and decide what should happen when someone changes an existing entry. A simple edit trigger does not run just because a formula recalculates, and changes made by another script or through an API do not trigger it in the same way as a person editing a cell. More complex automation may need a different trigger design.
Format the timestamp and check the time zone
To show both date and time, select the relevant cells and choose Format > Number > Date time. For a particular display, use Format > Number > Custom date and time and select or create a pattern. For example, a display might show a four-digit year and seconds, while another might use a short date and omit seconds. Formatting changes the display, not the underlying value.
Check the spreadsheet’s time zone if a timestamp appears several hours ahead or behind expectations. Open File > Settings and review the time zone under the general settings. This setting matters for interpreting dates and times in formulas and script-written values. If a script project also has its own time-zone setting, keep it consistent with the spreadsheet where appropriate. Avoid manually adding or subtracting hours as a fix before checking the settings; that can make later entries inaccurate.
Common problems and misconceptions
- The timestamp keeps changing. The cell likely still contains
=NOW(). Copy it and use Edit > Paste special > Values only to freeze the displayed result. - Only the date appears. Apply a date-and-time number format. The time may be stored even when the current format hides it.
- The time is wrong. Check File > Settings for the spreadsheet time zone and confirm the device or account context if relevant. Formatting alone will not correct a time-zone mismatch.
- A formula does not timestamp a row once.
NOW()is designed to update; it is not an automatic “time this edit and never change it” function. - The script misses some changes. The example only handles single-cell edits made in column A from row 2 down. Multi-cell pastes, edits in other columns, and formula recalculations fall outside its conditions.
Another common misconception is that changing a cell’s number format changes the timestamp itself. It only changes the presentation. Similarly, replacing the formula with a pasted value freezes the displayed date and time, but it does not create a protected or tamper-proof audit record. People with permission to edit the sheet may still alter the value.
Choose between shortcuts, formulas, and automation
For occasional manual entries, a keyboard shortcut is quick and creates a fixed date or time. If you need a combined timestamp, =NOW() followed by Paste special > Values only is convenient. For a live clock or refresh indicator, keep the formula. For a repeated process where each row needs a fixed timestamp as it is entered, Apps Script can reduce manual work, but it requires clear rules about which edits count.
Excel differs in interface and automation: the Google Sheets menu paths and Apps Script example above apply to Sheets in a browser, not Excel. Excel has its own date/time shortcuts and automation tools, so do not assume that a Sheets shortcut or script will work there. For either spreadsheet, keep in mind that an editable cell is not the same as a formal audit log; use a purpose-built record system if you need stronger change history or access controls.
Frequently Asked Questions
How do I insert the current date and time in one Google Sheets cell?
Enter =NOW(), copy the cell, then choose Edit > Paste special > Values only to keep that moment as a fixed value. Apply a date-and-time number format if the display omits part of the timestamp.
Does NOW() create a permanent timestamp?
No. NOW() is a live formula and can recalculate. To keep its current result, replace the formula with its value using Paste special > Values only, or use an appropriate automation script.
How can I automatically timestamp a row when I enter data?
Use an Apps Script edit trigger that watches the input column and writes a date value to the timestamp column. Define whether edits, replacements, deletions, and multi-row pastes should create or preserve timestamps; a simple formula alone does not provide that fixed-once behavior.
Why does my timestamp show only a date?
The cell may be using a date-only number format. Select it and choose Format > Number > Date time, or select a display under Custom date and time.
Can I make a timestamp impossible to change?
Not merely by inserting it. A pasted value or script-written date remains editable by people who have permission to change the sheet. Use protected ranges to limit ordinary edits, and use a system with suitable audit controls if you need a stronger record.
Related
- Unmerge Excel Cells Without Losing Data
- Excel Zoom Bar: How to Change Worksheet Magnification
- XL Number in Excel: Column 636 or Roman 40 Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert Speaker Notes in PowerPoint Step by StepTo insert speaker notes in PowerPoint, open the presentation in Normal view, select a slide, and click Notes…
- How to Make a Number Negative in Excel: Three MethodsTo make a number negative in Excel, type a minus sign before it, or use a formula such…
- Creating a Booklet in Word: Setup, Pages, and PrintingTo create a booklet in Microsoft Word for Microsoft 365 on Windows, open Layout > Margins > Custom…
- How to Password Protect an Excel File from OpeningTo stop someone opening an Excel file without your permission, open it in Excel for Microsoft 365 on…
- Excel Middle Years Academy: What Families Should KnowExcel Middle Years Academy appears to be the name of a school or education provider, not a Microsoft…
- Open Unsaved Excel Files: Recovery and Next StepsTo open an unsaved Excel workbook in Microsoft 365 for Windows, select File > Open > Recent, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.