Excel 2013 Filters and Advance Filters
Excel 2013 - Filters and Advance Filters Worksheet may contain a lot of content, so it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need. To filter data In order for filtering to work correctly, your worksheet should include a header row , which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1. Select the Data tab, then click the Filter command. 2. A drop-down arrow will appear in the header cell for each column. 3. Click the drop-down arrow for the column you want to filter. In our example, we will filter column B ...