0
Filter allows you to reduce down the amount of cells you see, by only showing ones that meet certain criteria. So if you had a list of numbers but only wanted to show ones that were above a certain value, you could use a filter to do that.
Wiki User
∙ 9y ago
Wiki User
∙ 8y agoIt allows you to define you own criteria to filter out cells from a list. This has many uses for a user of Excel. You can choose to list cells that fit certain conditions, like choosing values within a set range that you define. So you could have a load of values and list just the ones between 50 and 100 for example.
Add your answer:
Earn +20 pts
How would you filter a list of names or numbers in a column in Microsoft excel Excel?
By means using Filter . From filtered column We should select Custom , In custom we should select begins with where we can give the name or number
When was Custom House for Excel DLR station created?
Custom House for Excel DLR station was created in 1855.
What condition requires that only one of the selected criteria be true for a record to be displayed in Excel?
It is when you are using an OR condition, which in Excel can be implemented through an OR function, or in an Advanced Filter by listing the criteria on different rows.
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
A formula prewritten by excel is called?
Function
Does the uplookvert function in Excel exist?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
In excel 2013 where are the various function categories stored on the Ribbon?
In Excel Where are the various function categories stored on the Ribbon?
What would you use to hold words you commonly use but that are not included in the main dictionary of excel?
You could use an Excel custom dictionary to add words that you commonly use but are not included in the main dictionary. By adding these words to the custom dictionary, Excel will no longer flag them as misspelled when you type them.
What is an excel query?
Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
What is the function of percentage in micro-soft Excel?
functions of excel
An If function within an if function in Excel is called what?
A nested if.
How can you establish the validity of a excel workbook?
by adding a custom view?
