How to filter data from a worksheet
Now we will see that we can filter data from a worksheet in MS Excel.
The first thing which we need to check when we want to filter any data is that no row should be empty.
Now we will go to our DATA tab and select 'Filter' option, which will bring a dropdown option beside every column, and hence we can select any column which we want to filter and inside it select data according to our requirement.
After doing this it will show us only the filtered data which we selected.
We can also filter our data by providing certain conditions by using 'filter option' option. In that we can limit or set our data as our requirement.
Share a personalized message with your friends.