what is filtering in MS Excel
Answers
Answer:
Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this.
Explanation:
Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this.
Place a cursor on the Header Row.
Choose Data Tab » Filter to set filter.
Set a filter
Click the drop-down arrow in the Area Row Header and remove the check mark from Select All, which unselects everything.
Then select the check mark for Size 36 which will filter the data and displays data of Shoe Size 36.
Some of the row numbers are missing; these rows contain the filtered (hidden) data.
There is drop-down arrow in the Area column now shows a different graphic — an icon that indicates the column is filtered.
Filterd Output
☞mark as brainlist pls
have a Beautiful day