Step 1 - Add an Extra ‘Index’ Column Enter a 1 in a blank cell of the Index column to the right of the data set. Drag the Fill Handle to the ...
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 ...
Advanced Excel Exercises with Solutions PDF