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.

An Excel Options dialog box will open. Click the Choose Command From list box button and select All Commands from the menu. Scroll down to the Camera command, click it, then click the Add button.