So, you have a list of data , maybe some names or some rows, and you want to filter by color . I'm going to show you how. It takes a few steps, so follow along. Here, I have IDs in one column and employee names in another column, and I've highlighted some, but I only want to see the ones that are highlighted, in this case, magenta. So, I'm going to select B and C columns. I'm going to go up to data . I'm going to create a filter . Now once I do that, I can click anywhere and I have this handy dandy filter right in the header row right next to employee name here in the C column. I have a little button and I can press that and I can sort A to Z. I can sort Z to A. I can even sort by color here. But I want to filter by color. And this in this case it's in the How To Sort A Filter Filter a Database in Google Sheets based on Dates, Checkboxes, and Dropdown selections!

fourth row. Filter by color . It's already selected none. But I want to you choose a fill color . already figured out the colors in my column. So, I'm going to just select magenta. And there you go. I'm filtering by color. Isn't that cool? And if you don't want to see that anymore, there is a button here in the menu bar sort of icons, you can remove that filter . And here in data , if you have a filter on, you can also remove that filter there. So, you have two options. You're watching better sheets here on YouTube. You have two options here for your next video. Before you go, comment down below if you have any question whatsoever, and I'll make future videos from those questions. But for right here, right now, one of these Study Better With Google Sheets Are You Frustrated With Sheets New Dropdown Chips?

videos could be your next Google Sheet. Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. 20 Google Sheets Tips for Bloggers Download Google Sheets