Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 51,588 times.
Learn more...
This How.com.vn 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
Download Article
Open your project in Excel. 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.
Select the column you want to filter. To select the entire column, click the header cell (which is usually a letter).Advertisement
Click Data. You'll see this tab in the editing ribbon above the spreadsheet editing space.
Click Filter. This is next to an icon of a filter.
Clicknext to the column that contains the data you want to filter. A window will drop-down.
Click the drop-down menu next to "By color" under the "Filter" header. 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.
Select either Cell color or Font color. 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]
Expert Q&A
Tips
References
About This Article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
