Function Problems

How to Enter a Fixed Current Time in Excel on Android

Nimra Malik Sep 25, 2026 870 views

Question details

The user needs to insert a static timestamp in Excel for Android that does not recalculate.

How to Enter a Fixed Current Time in Excel on Android

Product: Microsoft Excel
Device & OS: Android
Scenario: Logging timestamps or the exact current time on a mobile device where standard desktop keyboard shortcuts are unavailable.
Observed behavior: The standard Ctrl+Shift+; shortcut does not work on Android, and using the =NOW() function results in a dynamically updating time rather than a fixed timestamp.

Before you start

Format your destination cells to display the correct time format (e.g., HH:MM) before you begin copying and pasting the timestamps to ensure the numbers display correctly.

Solution 1Recommended

Use a Helper Cell and Paste Values

By generating the current time in a helper cell and pasting it as a value, you can freeze the timestamp so it no longer updates dynamically.

Since the Android app does not support the desktop shortcut for inserting the current time, you must rely on a combination of the NOW function and the Paste Values feature.

Create a helper cell

Select an empty cell, preferably in a frozen top row for easy access, and enter the formula =NOW().

Copy the time

Tap the helper cell containing the =NOW() formula and select 'Copy' from the pop-up menu.

Select the destination

Tap the cell where you want to insert the fixed timestamp.

Paste as values

Tap the destination cell again, choose 'Paste' (or 'Paste Options' depending on your app version), and select 'Values'. This pastes the time as a fixed number, removing the formula.

Recalculate Before Copying: The =NOW() helper cell might not update automatically if the sheet is idle. Force a recalculation or edit a cell briefly before copying to ensure you are grabbing the exact current time.

Seamless Mobile Spreadsheets

Manage Data and Timestamps Easily with WPS Office

WPS Office provides a highly optimized mobile spreadsheet experience. You can effortlessly insert timestamps, apply advanced cell formatting, and use special paste options right on your Android device.

1. Open your file: Launch the WPS Office Android app and open your spreadsheet.
2. Generate the time: Type =NOW() into a reference cell to get the current date and time.
3. Copy the cell: Tap the reference cell and select 'Copy' from the quick action bar.
4. Paste Special: Tap your target cell, select 'Paste Special', and choose 'Paste Value' to lock the timestamp in place.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Intuitive touch controls for copying, pasting, and formatting data on mobile.Lightweight app design that runs smoothly on all Android devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the =NOW() function keep changing the time?

The =NOW() function is a volatile formula that recalculates automatically whenever the spreadsheet is updated or opened. This is why it cannot be used on its own to log a fixed timestamp.

Can I use external keyboard shortcuts to insert time on Excel for Android?

No, the Android version of Microsoft Excel does not currently support the standard desktop keyboard shortcuts (like Ctrl+Shift+;) for inserting the current time, even if you are using a physical Bluetooth keyboard.

How do I show only the time instead of the date and time?

Select the cell containing your pasted value, open the formatting menu, navigate to 'Number Format', and select a 'Time' format rather than the default 'Date/Time' setting.

Excel & Data Problems