Ever found yourself working on a complex Excel spreadsheet, only to realize you've made a mistake or want to revert to a previous state? The Control + S (or Command + S on Mac) keyboard shortcut is your friend, but what if you want to save multiple versions or go back to a specific point in time? That's where the 'control save' feature in Excel comes into play.

Also known as version control or tracking changes, this feature allows you to save different versions of your workbook, compare them, and even revert to a previous state if needed. It's particularly useful in collaborative environments or when working on critical documents where you want to keep a record of changes made.

Understanding the Control Save Feature in Excel
Before delving into the specifics, let's clarify what control save is not. It's not a built-in feature in Excel. However, you can achieve similar results using a combination of Excel's built-in tools and some additional steps.

In this article, we'll explore how to create and manage multiple versions of your workbook, track changes, and revert to a previous state using Excel's built-in features and a simple workaround.
Creating Multiple Versions of Your Workbook

To create multiple versions of your workbook, you can simply save it with different file names. Here's how:
- Press Ctrl + S (Windows) or Cmd + S (Mac) to open the Save As dialog box.
- Change the file name to reflect the version (e.g., "Project_X_V1", "Project_X_V2", etc.).
- Choose the save location and click Save.
Repeat these steps whenever you want to create a new version.

Tracking Changes in Excel
While Excel doesn't have a built-in 'track changes' feature like Microsoft Word, you can use conditional formatting and color coding to monitor changes. Here's how:
- Select the cells you want to track.
- Click on the Home tab, then click on Conditional Formatting in the Styles group.
- Choose Highlight Cells Rules, then Equal to.
- In the 'Format cells that are' dialog box, enter an unlikely value (e.g., "0") and choose a formatting style (e.g., fill color). Click OK.

Now, any changes made to the selected cells will be highlighted, allowing you to track modifications.
Reverting to a Previous State in Excel




















Unfortunately, Excel doesn't have a built-in 'undo' feature that allows you to revert to a specific state in the past. However, you can use a simple workaround involving the 'Save As' feature and some version control.
Here's how to revert to a previous state:
- Rename your current workbook to reflect the current version (e.g., "Project_X_V3").
- Open the version you want to revert to.
- Save it with a new name (e.g., "Project_X_V4") to create a new version.
Now, you've successfully reverted to a previous state and created a new version in the process.
Comparing Workbook Versions in Excel
To compare workbook versions, you can use the 'Compare and Merge Workbooks' feature in Excel. Here's how:
- Open both workbooks you want to compare.
- Click on the Developer tab (if it's not visible, go to File > Options > Customize Ribbon and check Developer).
- In the Compare group, click on Compare and Merge Workbooks.
- Follow the prompts to compare and merge the workbooks.
This will help you identify differences between the two versions.
In the dynamic world of data analysis and reporting, the ability to control and manage changes in your Excel workbooks is a valuable skill. By understanding and utilizing the features discussed above, you can effectively create multiple versions, track changes, revert to previous states, and compare workbook versions. Happy Exceling!