Sorting data in Excel is a very common task. Watch Excel Video 261 to see how to sort data and how NOT to sort data in Excel. Sorting data is a powerful way to focus on the important parts of your Excel data. If you aren’t careful when you sort, however, you can scramble your data and make things much worse. In this video I’ll show you how sorting can scramble your data, the warning Excel gives you when your data can get scrambled, and how selecting the entire range of data keeps the data you sort together.
I’ll also introduce the custom sort window that allows you to customize how Excel sorts and how to sort on multiple fields at once. There is some good functionality in the Custom Sort window. We’ll review that functionality in the next Excel Video. Thanks for watching.
