10. Sorting Data

Image

In this chapter, you’ll learn the various ways of sorting data, allowing you to view data from least to greatest, greatest to least, and even by color. You’ll also learn how to do the following:

Sorting data with one click

→ Sorting using a custom, non-alphabetical order

→ Sorting by color or icon

Rearranging columns with a few clicks of the mouse and keyboard

You’ll often need to sort your data, whether it be numerically, alphabetically, by color, or by icon. You aren’t limited to sorting the rows—columns can also be sorted.

Sorting data allows you to change how you view it. For example, if your dataset has a date column, ...

Get My Excel 2016 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.