Ready to Checkout?

shopping-cart

Try the Excel Course for Free!

Use a Top 10 AutoFilter in Excel – Tutorial

by / Monday, 05 December 2016 / Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365

Use a Top 10 AutoFilter in Excel: Overview

            You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of a column. However, you could also change it to show you the bottom 5 items by value within a column, too. Note that you cannot use a Top 10 AutoFilter in Excel on text fields. This is because text fields have no numeric ranking by which to base a value.

            To use a Top 10 AutoFilter in Excel, click the AutoFilter drop-down arrow button next to the column heading for the field by which you want to filter the table. Next, roll down to the “Number Filters” choice. Then select the “Top 10…” option from the side menu that appears to open the “Top 10 AutoFilter” dialog box.

Use a Top 10 AutoFilter in Excel – Tutorial: A picture of the “Top 10 AutoFilter” dialog box in Excel 2016.
Use a Top 10 AutoFilter in Excel – Tutorial: A picture of the “Top 10 AutoFilter” dialog box in Excel 2016.

            In this dialog box, select the first drop-down and pick either “Top” or “Bottom.” Next, enter a number into the spinner box in the center of the dialog box. Finally, use the drop-down on the right to pick either the “Items” or “Percent” choice.

            The information displayed across the dialog box is the filter setting that you will apply to the selected column. So, you could view only the “Top 10 Items” or “Bottom 40 Percent” or any other variation using this dialog box. When you have created the desired filter, just click “OK” to apply it.

Use a Top 10 AutoFilter in Excel: Instructions

  1. To use a Top 10 AutoFilter in Excel, click the AutoFilter drop-down arrow button next to the column heading for the field by which you want to filter the table.
  2. Roll your mouse down to the “Number Filters” choice.
  3. Select the “Top 10…” option from the side menu that appears.
  4. In the “Top 10 AutoFilter” dialog box, select the first drop-down and pick either the “Top” or “Bottom” choice.
  5. Enter a number into the spinner box in the center of the dialog box.
  6. Use the drop-down on the right to pick either the “Items” or “Percent” choice.
  7. The information displayed across the dialog box is the filter setting that you will apply to the selected column.
  8. When you have created the desired filter, click “OK” to apply it.

Use a Top 10 AutoFilter in Excel: Video Lesson

            The following video lesson, titled “Using the Top 10 AutoFilter,” shows you how to use a Top 10 AutoFilter in Excel. This video lesson is from our complete Excel training, titled “Mastering Excel Made Easy v.2016-2013.”

TOP