Leave a Reply

Your email address will not be published. Required fields are marked *

How to Sort and Filter Your Data in Microsoft Excel

Updated on: Dec 29th, 2015
Data Analysis
, , ,

Have a list of words that need some alphabetizing? Have a list of numbers that you want to arrange from least to greatest or greatest to least? Rather than painstakingly rearranging your rows by hand, let Excel’s Sorting and Filtering features do the heavy lifting for you.

How to Sort Data

Most folks are familiar with Excel’s Sorting feature. (And if not, you’re going to love it!) The Sort button is located within your Data tab.

Instructions:

  • Highlight or select the data that you want to re-order.
  • Go to the Data tab.
  • Select the Sort icon.
  • In the pop-up window, choose how you want to organize your data, e.g., alphabetically or from greatest to least.

Bonus! You can also create multiple layers of sorting by clicking the Add Level button within that same pop-up window. For example, you might first sort by gender and then by age.

Ann K. Emery on sorting your dataset

How to Filter Data

Have you seen the Excel’s Filters option yet? It’s hiding within plain sight on the Home tab. Filters are one of my all-time favorite features of Excel because, for me, they’re even easier to use than sorting, and they save valuable time as I’m wading through so many numbers.

Instructions:

  • Highlight or select the top row of data (or whichever row has your labels in it – it might be the second or third row if you’ve got any empty space at the top of your spreadsheet).
  • Go to the Home tab.
  • Click on the Sort & Filter button and then select Filter.
  • Tiny boxes with tiny arrows will appear on each of the cells in the top row of your dataset. Congratulations, you’ve got filters!
  • Click on the arrows to sort the data from smallest to largest or largest to smallest, to sort from A to Z or from Z to A. Or, use the checkboxes to filter the data. For example, you might only want to look at males, or only at females. The filtered-out data hasn’t been deleted and you can make it reappear at any time by simply re-checking the filter’s checkbox.

Bonus! Use your new filters to arrange your dataset by colors. Sometimes I use red, yellow, or green colors to indicate whether items are high, medium, or low priorities for me. I can filter my dataset so that the reds appear on top, followed by the yellows, followed by the greens.

Ann K. Emery on filtering your dataset

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Leave a Reply

Your email address will not be published. Required fields are marked *

You Might Like

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

How to Bring Your Technical Tables to Life

Just because I’m pro-graph, I’m not anti-table. Technical tables have so much value, especially as visual appendices for reports. In this blog post, you’ll get ideas for bringing your technical tables to life.

More »

Need some time-savers in Excel? Feel like all the formulas are taking forever? Learn how to clean, analyze, and tabulate your dataset.

Enroll

Subscribe

Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.