How to sort an Excel Table

Abstract

In this video, we’ll look at how to sort anExcel Table.

once you nail an Excel Table, it’s very easy to sort the columns.

Commands for sorting, like commands for filtering, are customized to match the contents of a column.

Dates will show options for Oldest and Newest.

In this case, I need to undo twice.

To sort first by one column, then by another, you should probably perform a Custom Sort.

You’ll find this option in the filter menu.

You’ll also get the custom sort dialog when you hit the large sort button on the Data tab.

Then add a level and sort by quantity.

Now when I click OK, colors appear together in alphabetical order.

Within each color, orders are sorted in reverse order, with larger numbers first.

Again, I can use undo to revert to unsorted data.

Remember that Excel does not permanently store the original order present when you open a file.