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
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 😅
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
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
Nope, very useful. I'm the guy that do the excel (vba and stuff) for my coworkers and a lot of them are stupid af, most need things like that to work. Btw, it's great also to make specific custom filter for somes, if i know someone only work with a bunch from the list, i let him choose his favorites directly in the excel to have shortcut.
Probably you never worked with extende data sheets and having to filter many options. Stop criticizing a little bit and be thankful, dude expended his time to teach people something… and you are here hating
@@nathanielaboagye2259 it's also used for tables like he did and allows u to make with it a lot more for example compile with a php file to create a login page