It’s common for Excel users to sort their data set when they’re analyzing. Sometimes, you may want to revert to the original data that you had before you did the sorting. In this tutorial, I will cover four techniques you can use to undo the sorting you have done on a dataset. ...
Method 1 – Use Ctrl + Z to Undo a Sort in Excel Press Ctrl + Z immediately after sorting your data. The Undo shortcut will instantly undo a sort and revert the data to its original state. This only works if sorting was the last thing you previously did. Method 2 – Use the Clear...
The Ctrl + Z shortcut doesn’t just work in Excel, it works in other Office programs like Word and PowerPoint and other programs as well. So, it’s such a helpful tip to know. What most people don’t know is that they can undo multiple actions at the same time Kasper Langmann, ...
Method 1 – Undo a Table by Converting to Range Steps: Select any of the cells in the table. In the ribbon, a tab named Design or Table Design will appear. Select Convert to Range in the Tools section. A confirmation box will appear. We will click on Yes. See that the table is ...
The Undo function in Excel works by reversing the last action you performed. For example, if you accidentally deleted a cell, you can undo that action by pressing the Undo button or the Ctrl+Z keyboard shortcut. Excel will undo the deletion and restore the cell to its previous state. You...
Windows users canundoin Excel with the keyboard shortcutCtrl+Zwhile Mac users can pressCommand+Z. You can repeat these keyboard shortcuts more than once to undo more actions. Another way to use theundooption in Excel is through theQuick Access Toolbar, which runs across the top of Excel ...
If you prefer to use a keyboard shortcut, selectCtrl + Yon Windows orCommand + Yon Mac. Note: You won’t see the Redo button available unless you use Undo first. How to Repeat Actions in Excel One more action you’ll find handy in Excel is the Repeat command. This allows you to pe...
You can undo the deletion of the text files by typing Ctrl+Z on your keyboard. After you hit the Delete button on your PC, you can try this to recover the deleted text. Click the "Undo" button from the toolbar at the top left of the Microsoft Word, Excel, PowerPoint, etc. program...
After modifying a worksheet, you may want to undo all changes to recover the original data of your worksheet. For Excel, it has the undo function to undo changes. But for undoing all changes you have done to the worksheet, it takes time to click the Undo button again and again. Actually...
If you now sort it by SKU (Column B) and want to undo that sort, the easiest way is to use the Undo button in the quick access toolbar (or use the keyboard shortcut CTRL + Z). As a result, records are again sorted by month and product. However, this option has constraints, as...