Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?