0

In Google Sheets, I may sometimes edit a cell, then edit another cell, and then decide that I want to undo the first edit.

Is that possible?

This also goes for rows, columns, sheets with a spreadsheet, ranges, etc.

0

No, edits can be undone only in the reverse chronological order: most recent one, then the one before it, etc.

In the situation you described, the easiest solution is to undo the last two edits (Ctrl-Z twice), copy the cell or range of interest, redo the edits (Ctrl-Y twice), and paste back into that cell/range.

To go further in time, you can use revision history (accessed by clicking "all changes saved in Drive", or from the menu). One cannot copy directly from revision snapshots, but you can restore some revision, copy a range of cell, go back to latest revision (which is now second-latest) and paste.

3
  • Is there a way to at least view changes by sheet, row or column, so that I can manually make the necessary changes? Mar 6 '16 at 5:42
  • 1
    Not as far as I know. Spreadsheets are a far cry from version control software.
    – user79865
    Mar 6 '16 at 5:47
  • While edits can still only be undone in reverse chronological order, you can now view the edit history of a cell (not row or column) so that you can manually make the necessary change: webapps.stackexchange.com/a/131938/164156
    – Brandon
    Jul 18 '19 at 20:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.