Undo and Redo
No matter how assiduous we are about saving our work, often, we’re just one keystroke or mouse click away from a spreadsheet catastrophe. For instance, Excel can, and does, crash without notice, making your work suddenly vanish from the screen. However, that’s an extreme example—it’s much more likely that you’ll delete the wrong data or accidentally paste over the wrong area of your worksheet. In such instances, pressing Ctrl + Z (or ⌘ + Z in Excel for macOS) will put things back. If you want to undo up to the last 100 actions in your workbook, you can click on the Undo drop-down menu, as shown in Figure 2.1, and select a series of consecutive actions to reverse:
Figure 2.1 – Available actions to undo
One hidden benefit of Undo is the ability to redo the actions that you’ve undone. This means that you can roll a spreadsheet back up to 100 steps to see how things looked at that point, and...
