Now, copying from a filtered table is quite straightforward. You will now see only the rows with Department “IT”. 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”.
You can click on any arrow to choose a filter for the corresponding column. These are meant to help you filter your cells.
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: