• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Show the Top Percents Of Your Data in Excel

July 30, 2021 by Andrew Childress
How to show the top percents of your data in Excel

When working in a spreadsheet, it’s useful to visually identify the top percents of your data. Here's how to show the top percents of your data in Excel.

When you’re working in a spreadsheet, it’s often useful to visually identify the top percents of your data. This is an easy way to see data that meets certain conditions. Fortunately, this is easy to do, thanks to Excel’s Conditional Formatting features. Let’s learn how to show the top percents of your data in Microsoft Excel.

How to Show the Top Percents of Your Data in Excel

Imagine a list containing a dozen numbers. This dataset spans a series of values, all between 0 and 100. Let’s say that you want to see the top 10%, 25%, or other percentage of this dataset. You could perform the analysis manually, but thanks to Conditional Formatting in Excel, you don’t have to.

To get started, click and drag your cursor to select the dataset. In this case, the data lies in the range A1:A12. Then, go to the Home tab. You’ll find that at the top of your screen, on Excel’s ribbon.

The option you’ll need lies in the Conditional Formatting dropdown menu, which is just right of center on the ribbon. Go ahead and click on it, and you’ll see an array of choices displayed. These are grouped by category, and the one you want will be in the Top/Bottom Rules subsection.

How to show the top percents of your data in Excel

Hover over Top/Bottom Rules to see your options. Since you want to see the topmost percentages in your data, go ahead and click on Top 10%.

On the New Formatting Rule menu, the percentage defaults to 10%, but you can easily change this. In this example, type in 25%. Finally, click OK.

Show top percent of data in Excel

Excel will highlight the three values – 98, 98, and 100 – that represent the top 25% of your dataset.

Top percent of data in Excel

As you can see, it’s easy to show the top percents of your data in Microsoft Excel. This is an excellent way to quickly visualize the upper elements in your data.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Format currency in ExcelHow to Format Currency in Excel
Next Post:Save Themes in ExcelSave themes in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top