how to go back on excel

"How to Revert to Previous Versions in Excel"

By Amanda Lopez
AD

Have you ever found yourself in a situation where you needed to revert changes made in your Excel sheet? Maybe you edited some cells and realized you accidentally altered important data, or perhaps you're working collaboratively and a colleague's changes aren't what you expected. Whatever the reason, Excel provides a way to go back to previous states with its 'Undo' and 'History' features. Let's delve into how you can utilize these to effectively manage your Excel data.

Excel allows you to undo and redo actions, saving the history of changes made on the document. This is particularly useful for correcting immediate or simple errors. But when you need to revert to a more specific point, like a state from an hour ago, the History feature becomes exceptionally valuable.

Using the Undo and Redo Function

The 'Undo' and 'Redo' features are straightforward and can swiftly rectify recent errors. They are your go-to tools when you've made a small but significant mistake.

AD
the excel hacks poster is shown in green and white, with numbers on it
the excel hacks poster is shown in green and white, with numbers on it
Must Know
Must Know
Excel Tips & Tricks
Excel Tips & Tricks

To use these functions:

  1. Click on the 'Undo' (Undo icon) or 'Redo' (Redo icon) icon on the quick access toolbar.
  2. Alternatively, you can use the keyboard shortcuts Ctrl+Z for 'Undo' and Ctrl+Y for 'Redo'. Repeat the steps to revert through or redo actions.

Understanding the History Feature

The history feature saves the state of your document at regular intervals. This allows you to go back to a specific point in time, making it incredibly useful when you want to revert to a state before you realized an error.

Best Excel tutorial on the internet
Best Excel tutorial on the internet
Top Excel Hacks on Merging Cells!
Top Excel Hacks on Merging Cells!

To access the history feature:

  1. Go to the 'File' tab.
  2. Click on 'Info'.
  3. At the bottom, click 'Manage Versions'.
  4. In the 'New Version' dialog box, enter a name, and click 'OK'.

Reverting to a Previous State

Once you've created versions, you can revert to a specific state.

AD

To do this:

  1. Open the 'File' tab.
  2. Click on 'Info'.
  3. Click on the arrow next to the filename, and in the dropdown, select the version you want to go back to.

Incorporating Macros for Automation

Macros can be utilized to automate tasks or revert to previous states in bulk. They are particularly useful if errors or changes were made across multiple cells.

While learning and using macros requires a bit more expertise, they can significantly boost productivity and efficiency in the long run.

AD

Recording a Macro

Excel allows you to record your actions as a macro. This can then be replayed at any time, whether it's to rectify a mistake or to automate a procedure.

To record a macro:

  1. Press 'Alt+F11' to open the 'Visual Basic for Applications' (VBA) window.
  2. In the 'Developer' tab, click on 'Record Macro'.
  3. Give your macro a name and a shortcut if you wish, then start performing the actions you want to record.
  4. When you're done, click 'Stop Recording'.

Excel's features for undoing, reverting, and automating changes provide a robust toolset to manage mistakes and streamline workflows. Mastering these features will help you gain confidence and efficiency in your Excel tasks. Don't be afraid to experiment with 'Undo', 'Redo',wartz!

AD
AD