You can undo the last change you made to a cell on a worksheet. Use this option if you make a mistake when you update your data, or to check the previous value of a cell.

You cannot undo a change made to a cell before you've opened a worksheet, or a change made by someone else. This means you can only undo a change you made while a worksheet is open.

Only the most recent cell change is reversible. To revert to an older cell value, right-click the cell and select Show history. Alternatively, select a cell and click the Cell history icon in the top-right of the grid. This displays older cell values, which you can manually re-enter.

To undo a cell change, press the default shortcut for undo on your operating system:

  • Ctrl-Z for Windows
  • Cmd-Z for Mac