yes for 4 regions . let’s say there are 30 nations . with filter you can type a few letters and pick the nation straight away . in your way it will take ages to find the nation by scrolling down the list
You can also right click on the value you want, like South, and in the right click menu there is a Filter option, select Filter by this value (or something like that, I'm on my phone and can't verify the exact command). The point is using the filter drop down, using slicers, or using my suggestion are all OPTIONS. They all perform the same task in different ways. They all have pros and cons and each option will be better suited for different situations. Use what works bet for the situation.
You’re correct - you can right-click any cell, hover over filter, and then filter by the selected cell’s value, color, font color, or icon 😊 We totally agree that you should use what works best for your situation! Awesome response 💚
This is really awesome. It would be great if I can get an answer for my query. Need to see the total consolidate sales amount across region wise. How to get it? Your prompt response is appreciated
People who are making such files are most likely sharing them with others on daily basis. This alone is a great trick. You can always combine that with a macro for making this trick much much much better. Be open minded in Excel 😅
I could see it being handy if you have a job making team jerseys - you have a list of the orderered jerseys, but you create a few filter options - by age group, by size, etc So you can get a visual of just one size, then go back to the full view easily