Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort.

Select Sort Largest to Smallest, and it’s done. You don’t even have to click OK. Notice that Grand Targhee Ski Resort in Targhee, Wyoming tops the list with an annual snowfall of 500 inches.

In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields. For this example, we’ll select ...

Set Excel’s custom millions format to this data set. To create an Excel conditional format rule that handles values that are greater than or equal to one million, do the following: Select the ...