Basic computer course, C programming language, Education, Engineering Course, Engineering Courses, Maths Coaching, online computer coaching, PGDCA course coaching, programming course, school computer coaching, training, Uncategorized, Web Design course

What is filter in Excel?

In database if we want to display specific data only, then we have to apply some condition on database. Which data have been satisfied the condition those data only will be appeared to the user. While hiding the other data .This process is called Filter in Excel.

filter in excel

It is done to make it easier to focus on specific information in a large dataset or table of data.

does not remove or modify data; it merely changes which rows or columns appear in the active Excel worksheet.

When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row. Excel gives you many options when it comes to filtering your data.

By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to
see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data that you want to see.

To learn Filter in Excel at TCCI.

Call us @ 9825618292

Visit us @


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s