We’ll start our discussion of Tables features in Excel Video 381 with sorting. The big advantage of sorting data in Tables is that you don’t have to select the entire data range to sort. If you’ve sorted data in Excel before, you know you have to carefully select the entire range of data to sort or Excel will scramble your data. Not in Tables. It’s easy to sort from A-Z or from Z-A in Tables without worrying about selecting all of the data first.
If sorting by one column isn’t good enough, watch for the Sort menu on the Data tab. You can sort by multiple columns, and I’ll show you how to rearrange the sort order if you need to. Watch how the sort window allows you to sort by cell color, font color, or cell icon. We’ll talk about sorting by color in the next Excel Video. I look forward to seeing you then.
