If you’re already using colour to organise your Excel spreadsheets, here’s some good news — you can filter by that colour too. Excel filter by colour lets you instantly show only the rows that match a specific colour — whether that’s a background fill or a font colour. It’s one of those features that feels like it should be complicated, but it really isn’t.
First, a Quick Note About Header Rows
Before we dive in, just make sure your table or list has a header row — that’s the row at the top with your column labels like “Task”, “Status”, and so on. Excel puts the filter drop-down arrows in that row. If you don’t have one, Excel will treat your first row of data as the header, which means it won’t show up in your filtered results. Easily avoided!
Switching the Filter On
If you haven’t already got filtering switched on, you can enable it in two ways:
- Go to the Home tab and use the Sort & Filter button
- Or head to the Data tab and click Filter
Either way, you’ll see small drop-down arrows appear in your header row. That’s your cue that filtering is ready to go.
Filtering by Background Colour
Click the drop-down arrow in the column you want to filter. You’ll see a Filter by Colour option roughly in the middle of the menu. Hover over it and Excel shows you all the colours it’s found in that column. Click the one you want and — that’s it. Your list instantly narrows down to just those rows.
You can switch to a different colour at any point by going back into the same drop-down. Just bear in mind you can only filter by one colour at a time.
Clearing the Filter
When you’re done, clearing the filter is just as straightforward. Go back to the drop-down and either:
- Click the colour again to deselect it
- Or choose Clear Filter From [Column Name]
Job done. Your full list is back.
Does This Work in Excel on the Web?
Yes! Excel on the web has the same Filter by Colour option. The steps are identical, so if you’re working in a browser rather than the desktop app, you’re not missing out.
Filtering by Font Colour
Here’s a bonus that catches people out: Filter by Colour works on font colour too, not just background fills. So if you’ve highlighted certain cells by changing the text colour rather than the background, Excel can filter by that as well. Same process, same menu — just look for the font colour options when you hover over Filter by Colour.
A Simple Feature With Real Practical Value
This isn’t a feature you’ll use every day — but if you colour code your spreadsheets to flag priorities, track progress, or categorise tasks, it becomes genuinely useful. Rather than scrolling through to find all your red “Urgent” rows, you can pull them up in two clicks.
Simple, quick, and surprisingly satisfying.
Created with the help of Claude AI from an original transcript.
YouTube Videos
Excel Flash Fill – Split Names, Create Emails & More in Seconds
How to Use Excel Sparklines to Spot Trends at a Glance
Excel Paste Special Values – Copy Exactly What You See on Screen
Already Colour Code Your Excel Data? Here’s How to Filter by Colour
Related Excel Tips Posts
Do You Know All the Excel Flash Fill Tricks?
Excel Sparklines: The Tiny Charts Making a Big Difference
Excel Paste Values – Get Exactly What You See, Every Time
Why Your Colour-Coded Excel Data Deserves a Better Filter (current post)
Recent Posts
- Copilot in PowerPoint Can Build, Design, or Suggest. Here’s How to Choose
There’s no single right way to use Copilot in PowerPoint. Your Copilot presentation options really come down to three starting points: build it yourself and let Copilot handle the design, hand the whole thing over and let Copilot generate it, or ask Copilot to suggest a direction first if you’re not quite sure. I tested… Read more: Copilot in PowerPoint Can Build, Design, or Suggest. Here’s How to Choose - Getting Your PowerPoint Designs to Actually Match
If you’ve ever used Design Ideas in PowerPoint and never ended up with a consistent PowerPoint slide design, you’re not alone. Each slide looks lovely on its own, but look at them as a complete deck and it’s like four different presentations got shuffled into one file. I was reminded of this exact problem recently,… Read more: Getting Your PowerPoint Designs to Actually Match - A Simple Framework for Better Copilot Prompts
I’ve been testing Copilot presentation prompts a lot this month, and this time I wanted to answer a simple question: does putting more thought into your prompt actually make a difference, or is it all a bit of a lottery? Starting simple I opened Copilot in PowerPoint desktop and hovered over the Copilot icon, which… Read more: A Simple Framework for Better Copilot Prompts - Moving From Corporate to Self-Employed: How to Set Up Your Tech Step by Step
TLDR: Moving from corporate to self-employed doesn’t mean starting your tech setup from scratch. It means being deliberate: keep what works, drop what doesn’t, and learn properly the bits you never had to before. Get this right early and the admin side of self-employment stops feeling like a second job. If you’re moving from corporate… Read more: Moving From Corporate to Self-Employed: How to Set Up Your Tech Step by Step - Copilot for Presentations: Same Prompt, Two Results
I’ve been having a proper play with Copilot for presentations lately, trying to work out whether it can genuinely save small business owners time when building a deck. Short answer: it depends. Longer answer: it depends on where you open it, and even then, results can shift from one day to the next. Why I… Read more: Copilot for Presentations: Same Prompt, Two Results
excel filter by colour, filter by colour, how to filter data by colour in excel, excel filter by color