answersLogoWhite

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.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

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.


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.


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 the function of percentage in micro-soft Excel?

functions of excel


How can you establish the validity of a excel workbook?

by adding a custom view?


An If function within an if function in Excel is called what?

A nested if.