GreenWizard
Board Regular
- Joined
- Dec 8, 2013
- Messages
- 106
This may sound impractical, but I need a quick way to filter columns. Does Excel offer anything similar to a slicer where a user can quickly click on a 'Type' and have the columns be filtered. It was my understanding Slicers are used to quickly filter Pivot Tables, while I need to simply quickly filter standard columns in a sheet.
For example:
Population Table
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Need a quick way to click Filter by State & Capital. Via Excel Slicer (?) or other.
<tbody>
</tbody>
Example Slicer/Dashboard/Buttons
<tbody>
</tbody>
*Note I realize it seems impractical to have a slicer or a dashboard with 50 buttons, but this is just an example and the data I'm filtering will have far less then 50 buttons (aprx 5-10). I also realize I can simply filter columns and then click on the the type columns (ex. State/Capital), but this requires additional clicks. I don't want to have to select the the group of columns > Filter > then select Capital=1 > then select State=TX. Is it possible to filter via 1-2 clicks via either clicking on 'TX' from a pre-set slicer/dashboard or clicking '1' (capital) then 'TX' via a slicer/dashboard.
Thank you
For example:
Population Table
<tbody> </tbody> |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Need a quick way to click Filter by State & Capital. Via Excel Slicer (?) or other.
| City | State | Capital | Rk |
| Austin | TX | 1 | 11 |
| Boston | MA | 1 | 24 |
| Columbus | OH | 1 | 15 |
| Denver | CO | 1 | 21 |
| Indianapolis | IN | 1 | 14 |
| Nashville | TN | 1 | 25 |
| Oklahoma | OK | 1 | 27 |
| Phoenix | AZ | 1 | 6 |
<tbody>
</tbody>
Example Slicer/Dashboard/Buttons
| State |
| TX |
| MA |
| OH |
| CO |
| IN |
| TN |
| OK |
| AZ |
<tbody>
</tbody>
*Note I realize it seems impractical to have a slicer or a dashboard with 50 buttons, but this is just an example and the data I'm filtering will have far less then 50 buttons (aprx 5-10). I also realize I can simply filter columns and then click on the the type columns (ex. State/Capital), but this requires additional clicks. I don't want to have to select the the group of columns > Filter > then select Capital=1 > then select State=TX. Is it possible to filter via 1-2 clicks via either clicking on 'TX' from a pre-set slicer/dashboard or clicking '1' (capital) then 'TX' via a slicer/dashboard.
Thank you
