You can simply uncheck “Select All” to quickly uncheck everything and then just select “IT”. So, select the arrow next to the Department header and uncheck the boxes next to all the departments, except “IT”. In this example, we want to filter out only the rows that contain the Department “IT”.You can click on any arrow to choose a filter for the corresponding column. These are meant to help you filter your cells. You will notice small arrows on every cell of the header row.From the Data tab, select the ‘Filter’ button under the ‘ Sort & Filter’ group.Given the above table, say you want to copy all the rows of employees from the IT department only.įor this, you can apply a filter to your table as follows:
