How to Filter by Color in Excel

PDF download Download Article
PDF download Download Article

This wikiHow will show you how to filter by color in Excel on your Mac or Windows computer. To be able to do this, you should have colored cells that you can filter; if you haven't colored any cells, you can apply conditional formatting .

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/80\/Filter-by-Color-in-Excel-Step-1.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/8\/80\/Filter-by-Color-in-Excel-Step-1.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can either open your spreadsheet within Excel by navigating to File > Open or by right-clicking the file in your file manager and selecting Open with > Excel .
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0c\/Filter-by-Color-in-Excel-Step-2.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/0\/0c\/Filter-by-Color-in-Excel-Step-2.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To select the entire column, click the header cell (which is usually a letter).
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7b\/Filter-by-Color-in-Excel-Step-3.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/7\/7b\/Filter-by-Color-in-Excel-Step-3.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this tab in the editing ribbon above the spreadsheet editing space.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/Filter-by-Color-in-Excel-Step-4.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/8\/8f\/Filter-by-Color-in-Excel-Step-4.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is next to an icon of a filter.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ad\/Filter-by-Color-in-Excel-Step-5.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/a\/ad\/Filter-by-Color-in-Excel-Step-5.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A window will drop-down.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dd\/Filter-by-Color-in-Excel-Step-6.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/d\/dd\/Filter-by-Color-in-Excel-Step-6.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll want to use the color field under "Filter" since the other field is only for setting how to sort the appearance on the spreadsheet.
    • You might see "Filter by color" instead.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Filter-by-Color-in-Excel-Step-7.jpg\/v4-460px-Filter-by-Color-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Filter-by-Color-in-Excel-Step-7.jpg\/aid12061380-v4-728px-Filter-by-Color-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Another menu will open to the right with color choices.
    • After you make a selection, only the color you chose will appear on the spreadsheet. [1]
    8. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Combine Columns in Excel Without Losing Data
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/filter-by-font-color-cell-color-or-icon-sets-4af3e865-3e34-4d81-9814-1893ffaada3c

      About This Article

      Article Summary X

      1. Open your project in Excel..
      2. Select the data you want to filter by.
      3. Click Data .
      4. Click Filter .
      5. Click the downwards-pointing arrow next to the column that contains data you want to filter.
      6. Click the drop-down menu next to "By color" under the "Filter" header.
      7. Select either Cell color or Font color .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 54,453 times.

      Is this article up to date?

      Advertisement