How to add slicers to a table to quickly filter your data in Excel?
Slicers are very useful if you want to filter data in your Excel tables. They provide greater clarity and save you time searching for information.
Use the following method:
1. Select your data with Ctrl + A (on Mac: ⌘ + A).
2. Insert a table with Ctrl + L (on Mac: ⌘ + T).
3. Click "Insert Slicer" in the dynamic "Table Creation" (or "Table") tab.
4. Separate the values of the slicer across multiple columns in the dynamic "Segment" tab.
5. Move your slicer above the table.
6. You can insert multiple slicers linked to a single table to filter your data more quickly.
7. You can also freeze the panes to keep your slicers on screen if you scroll down the spreadsheet.
🎯 Train with us
⇢ Our training courses: https://www.morpheus-formation.fr/
⇢ Our e-learning platform: https://www.elearning.morpheus-format...
⇢ Contact us: [email protected]
🎁 Download our e-book "Mastering Excel Functions from A to Z" now
https://www.morpheus-formation.fr/blo...