Search

Home > Daily Office Tips by Office ToDo > 102 Excel | How to see top values within my list?
Podcast: Daily Office Tips by Office ToDo
Episode:

102 Excel | How to see top values within my list?

Category: Technology
Duration: 00:00:36
Publish Date: 2010-12-10 17:01:22
Description: First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Top 10 Items …” In the menu you can choose the number of top values shown. By default the number is 10. From the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. - Office ToDo
Total Play: 0