How to insert and filter using slicers in Excel

Excel spreadsheet is a very easy-to-use office software with rich and powerful functions. If you want to insert a slicer into an Excel table to facilitate filtering data, how do you do it? In fact, the operation method is very simple, just a few very simple steps are enough. Next, the editor will introduce the method. Setting method 1. Double-click to open the Excel table to enter the editing interface, select the data area (only select the header and the content below, do not select the title), press Ctrl+T, or click the Apply Table Format button in the Home tab and select a desired format.

2. In the opened window, check or uncheck the table contains title as needed and confirm.

3. After converting the table into a super table, bring Agricultural Machinery Design under the table tool - insert the slicer, check the required filtered data and confirm.

4. You can get the slicer. Click the options in the slicer to quickly filter. Click the icon with × in the upper right to clear the filter and restore the display of all data.

5. Click the icon as shown in the upper right corner to make multiple selections. After clicking to select the slicer, you can also set the slicer style, etc. in the slicer tool above.

The above is the detailed content of How to insert and filter using slicers in Excel. For more information, please follow other related articles on the PHP Chinese website!