Chat with us, powered by LiveChat

Undo, Redo, and Repeat

How to Undo, Redo, and Repeat in Google Sheets

Undo, Redo, and Repeat

You're going to make mistakes at some point when you're using Sheets. When this happens, you can use the handy undo command to instantly undo your last action. The related redo and repeat commands are also useful and powerful.

Undo and Redo

To see how they work, you first need an action that you can undo.

  1. Click the Undo button on the toolbar to undo the last action.

    Press Ctrl + Z.

    Undo, Redo and repeat

    Your last action is undone. For example, if you had deleted an item and then decided you wanted to keep it after all, undo would make it reappear.

  2. Click the Redo button on the toolbar to redo the last action.

    Press Ctrl + Y.

    Undo, Redo and repeat

The last action you undid is redone.

Repeat the Last Action

  1. Select the cell where you want to repeat the last action performed.
  2. Click the Redo button.
    Undo, Redo and repeat

The last action is repeated for the selected cell.

FREE Quick Reference

Click to Download