How to Create a Custom Sort in MS Excel

by Kathryn Hatashita-Lee
Excel's "Custom Sort" command can refine a sort with filters.

Excel's "Custom Sort" command can refine a sort with filters.

Microsoft Excel 2010 can sort a range of cells on a worksheet. For example, a column of last names can sort from A to Z. Excel's "Home" tab on the command ribbon contains a "Sort & Filter" command in the "Editing" group. The "Custom Sort" option can sort a range by column, and further refine the sort with additional filters, such as values or cell color.

1

Open the Excel worksheet.

2

Click and drag to select the range of cells you wish to custom sort.

3

Click the "Home" tab on the command Ribbon.

4

Click the "Sort & Filter" button in the "Editing" group. A list of options appears.

5

Click the "Custom Sort" option. A dialog window opens. The categories include "Column," "Sort On" and "Order"

6

Select or deselect the check box for "My data has headers."

7

Click the arrow next to the "Sort by" text box in the "Column" category. Select the "Column."

8

Click the arrow in the text box under "Sort On." Select the preferred option, such as values or cell color.

9

Click the arrow in the text box under "Order." For example, "Smallest to Largest" for values, or "A to Z" for text.

10

Click the "Options" button. A small dialog window opens. Select the orientation for sorting, such as "Sort left to right" or "Sort top to bottom." Click "OK." This window closes.

11

Click "OK." The "Sort" window closes. The range of cell contents display the new order.

Tips

  • check The "Sort" window also includes "Add Level" and "Copy Level" buttons that insert extra lines of filters to refine this custom sort.
  • check The "Data" tab on the command Ribbon also contains a "Sort" button in the "Sort & Filter" group.

Photo Credits

  • photo_camera Jupiterimages/Comstock/Getty Images