Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Steps

Practice Data

4. Release the mouse button. The table moves to the new position.

Release the mouse button

S ORTING D ATA BY M ULTIPLE L EVELS  D ISCUSSION

The Sort options available from the Filter buttons in the table Header Row only let you sort the table rows using the entries in a single column of the table. However, when a column contains many entries that are the same, such as a Region column, you may want to add a second level of sorting to organize the rows within each Region. By using the Sort dialog box, you can add as many levels of sorting as you need. You can use the entries in any column to sort table data. Text columns let you sort the data from A to Z or Z to A. Number columns let you sort from Smallest to Largest or Largest to Smallest. Date columns and Time columns let you sort from Oldest to Newest or Newest to Oldest. You can also sort by a custom list (such as month names, which do not produce the result you need when sorted alphabetically) or by the cell format (such as the Cell Color, Font Color, or Icon Set applied to cells by conditional formatting).

OFFICEPRO, Inc.

Page 43