When sorting A-Z or Z-A isn't good enough, watch Excel Video 283. Today we'll discuss how manually sort data. When you need data in a different order then ascending or descending, just turn on manual sort and you can drag items in your list to rearrange them just the way you need to. When you drag, the trick is to wait for the cursor to change to the four-way arrow. When I teach live classes where participants bring their laptops and follow along, I've seen folks struggle to get this to work with the touchpad on their laptops. For me, manually sorting is much easier with a mouse.

This is what I wanted to say about sorting data. Now that we've covered sorting and filtering, stay tuned next time as we start discussing filtering data in Pivot Tables. I look forward to seeing you then.

свернуть