How to display the top 20 items in a excel worksheet?


Alister Doyle, I work at Noodle.

User avatar for Alister Doyle

Hi there. If you go to the 'Data' tab in your Excel worksheet, you should see a section labelled 'Sort & Filter' which lets you sort items in descending order. You can also use Conditional Formatting to highlight the top 20 items without sorting them if you want. This is on the 'Home' tab under 'Styles'. I hope that makes sense but here is a video just in case you need it. Best of luck!

Your Answer