Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.

Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.

Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.

Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by When you need to undo all changes and get back the original data of the worksheet, just click the snapshot you took to restore it. In the Track Snap dialog box, click the OK button. Before modifying the worksheet, Click Kutools > Snap > Track Snap. Undo all changes to get back the original data with Kutools for Excelĭo you want to restore to the original data with just one click? With the Snap utility of Kutools for Excel, you can take a snapshot of current worksheet before modifying, and then get back the original data with one click.īefore applying Kutools for Excel, please download and install it firstly.ġ. Press the F5 key to run the code, then a worksheet named backup is created with exactly the same content with the specified worksheet. VBA code: Back up worksheet Sub CreateBackup() In the Microsoft Visual Basic Application window, click Insert > Module, and then copy and paste the below VBA code into the Module window. Stay in the worksheet and keep the original data you want to back up, then press Alt + F11 to open the Microsoft Visual Basic Application window.Ģ. With the following VBA code, you can easily back up the worksheet.ġ.

Undo all changes to get back the original data with backupĪnother method for quickly getting back the original data after modifying worksheet is to back up this sheet before modifying. So, to undo all changes in a specified worksheet with this method becomes complex. If the other worksheets in current workbook was modified, changes of these worksheets are listed in the Undo list as well.

How to do an anova in excel 2007