The undo list is a history of the changes that you have made to a workbook. It is located on the Quick Access Toolbar, and can be accessed by clicking the Undo button or pressing CTRL+Z. The undo list can be used to undo multiple changes, and can be saved so that you can continue working on your workbook at a later time.
To preserve the undo list in Excel, you need to do the following:
- Open the workbook that you want to save.
- Click the File tab.
- Click Save As.
- In the Save As dialog box, click the Tools button.
- Click General Options.
- In the General Options dialog box, select the Preserve Undo History check box.
- Click OK.