How to Undo in Google Sheets on Desktop and Mobile

Author

Reads 0

White blocks with letters spelling Google, symbolizing search and SEO concepts.
Credit: pexels.com, White blocks with letters spelling Google, symbolizing search and SEO concepts.

On desktop, click the left-pointing curved Undo arrow in the top-left toolbar; click it repeatedly to undo additional recent steps. On mobile, tap the left-pointing curved arrow at the top of the Google Sheets app.

Undo history is session-specific and is cleared after saving and reloading or closing and reopening the sheet. Some actions cannot be undone; Version History is the retained recovery option.

Broaden your view: Harveys Bristol Cream

Undo on Desktop

In Google Sheets on desktop, click the left-curved Undo arrow in the top-left toolbar to reverse the last action. Click it repeatedly to undo more recent actions in the order they were performed.

See what others are reading: How to save Google Spreadsheet to Desktop

Undo on Mobile

In the Google Sheets mobile app for iOS and Android, tap the top left-curved arrow to undo and the right-curved arrow to redo.

Why Undo May Not Work

Undo history is session-specific and some actions cannot be undone. Version History is the retained recovery option.

  • You've saved and reloaded the sheet. The undo history is specific to your current session. If you close your browser tab and reopen the sheet, your previous undo/redo history is cleared.
  • The action cannot be undone. Certain actions, especially those performed by third-party add-ons or complex scripts (Apps Script), may not be added to the undo stack. In these cases, there is no history of the change to revert.
  • You've reached the end of the history. You can only undo a finite number of steps within a session. If you've pressed Ctrl+Z dozens of times, you may have simply reached the earliest change recorded in your current session.
  • Permissions have changed. In a shared workbook, if another user with editor or owner privileges changes your permissions while you're working, it can interrupt your session's edit history.

Version History as a Recovery Option

Version History operates independently of the session-based undo stack and serves as your ultimate safety net for almost any change.

On mobile, Version History is accessible by tapping the three-dots menu in the top-right corner and selecting "Version history," though navigating an extensive history is often easier on a desktop.

Frequently Asked Questions

How do I undo an action in Google Sheets on a desktop computer?

Click the left-curved Undo arrow in the top-left toolbar to reverse the last action. Click it repeatedly to undo more recent actions in the order they were performed.

How do I undo an action in the Google Sheets mobile app?

In the Google Sheets mobile app for iOS and Android, tap the left-curved arrow at the top of the screen to undo. The right-curved arrow is Redo.

Why can't I undo an action in Google Sheets?

Undo history is specific to your current session, so it is cleared if you save and reload the sheet or close and reopen it. Some actions, especially those from third-party add-ons or complex scripts, may not be added to the undo stack. You can also reach the end of the finite history recorded in the session, and in a shared workbook, a permissions change by another user can interrupt your session's edit history.

What can I use to recover changes if undo does not work?

Version History operates independently of the session-based undo stack and serves as your ultimate safety net for almost any change.

How do I access Version History on the Google Sheets mobile app?

Tap the three-dots menu in the top-right corner and select "Version history," though navigating an extensive history is often easier on a desktop.

Patricia Dach

Junior Copy Editor

Patricia Dach is a meticulous and detail-oriented Copy Editor with a passion for refining written content. With a keen eye for grammar and syntax, she ensures that articles are polished and error-free. Her expertise spans a range of topics, from technology to lifestyle, and she is well-versed in various style guides.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.