The Select All button sits at the upper left of all worksheets, at the origin of row and column labels. You can use the Select All button to quickly select all cells in a worksheet. This can be a convenient way to apply or remove global formatting from a worksheet.
When entering a formula, you can click the Select All button to enter a reference that refers to all cells in a worksheet. For example, if you create a formula based on the COUNTA function, and click Select All in Sheet2 when entering the first argument, you’ll get:
=COUNTA(Sheet2!1:1048576)
The reference Sheet2!1:1048576 is a range that includes every row in Sheet2, automatically entered by Excel when you click Select All. Because each row contains all columns, the reference contains every cell in the workbook.
A slicer is a control that lets a user filter a Pivot Table or an Excel Table using buttons. A slicer provides the same function as using filter controls to filter a list. However, instead of drop-down menus, slicers provide large, friendly buttons that are always visible. The buttons are created automatically based on values in the data.
In the example shown, the slicer is set up to filter on the Department field in the data. Because there are five values in the data (Engineering, Fulfillment, Marketing, Sales, and Support) the slicer makes provides buttons with these names.
