• 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 Bottom Percents Of Your Data in Excel

July 29, 2021 by Andrew Childress
Show bottom percents of your data in Excel

As you work in Excel, it’s very useful to identify the bottom percents of your data. Here's how to show the bottom percents of your data in Excel.

As you work in Excel, it’s very useful to identify the bottom percents of your data. This is a great method that lets you identify values that meet those conditions. Fortunately, this is quite easy to do. Let’s learn how to show the bottom percents of your data in Microsoft Excel.

How to Show the Bottom Percents of Your Data in Excel

Consider a list of data containing a dozen values. You want to visually identify those values that represent the bottom 10%, 25%, or other percentage within the dataset. This analysis could, of course, be performed manually with Excel’s sort features. But thanks to options in the Conditional Formatting dashboard, you can do the work much faster and more efficiently.

To get started, go ahead and click and drag your cursor to highlight your range of values. In this example, the values are contained in cell range A1:A12. Then, find the Home tab on Excel’s ribbon. The ribbon is the menu and controls found at the top of your screen, just above the worksheet.

Click next on the Conditional Formatting dropdown menu. You’ll see an array of options here, grouped into several categories. The subsection you’re looking for here is called Top/Bottom Rules. Hover over it, and you’ll see yet more options displayed.

How to show the bottom percents of your data in Excel

Since you’re looking for bottom percents in your dataset, the option you need is called Bottom 10%. Go ahead and click on it, and Excel will display the New Formatting Rule menu. Notice that it defaults to 10%, but you can easily adjust this value to fit your needs. Here, change it to 25%, then click OK.

Show bottom percents of your data in Excel

Excel will highlight the values in your dataset that represent the bottom 25% of the data: 25, 43, and 55.

Bottom percent of your data in Excel

As you can see, it’s easy to show the bottom percents of your data in Microsoft Excel.

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

About Andrew Childress

Previous Post:Fractions in ExcelHow to Format Fractions in Excel
Next Post:How to Format Currency in ExcelFormat currency 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