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 – 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 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 ...
PressCtrl + Zimmediately 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 Command to Undo a Sort in Excel This method works if yo...
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...
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...
Whichever your case is, you can change and use custom formatting to avoidcommas in numbers. Select the cell(s) containing commas. Press Ctrl + 1. Select the Number tab. Then, choose Number under the Category section. Uncheck theUse 1000 Separator (,)checkbox. ...
If it doesn't work for you, try pressing F-Lock or Fn, and then the F4 key. Similar to Undo, this Redo shortcut works in various applications, not just Excel. If needed, you can hit the Redo shortcut more than once to reapply multiple actions that were undone in succession. How ...