First, when you hide columns in Excel (by right-clicking the relevant column or columns, and clicking "Hide"), it's easy for you or others to forget that the spreadsheet contains hidden data.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.