answersLogoWhite

0

How do you apply filters in spreadsheets?

Updated: 8/18/2019
User Avatar

Wiki User

14y ago

Best Answer
  1. Click on the column letter (or highlight a range) that you want to filter.
  2. In Execl 2007, select the data tab and look in the Sort & Filter section or on the Home tab, look in the Editing section.
  3. Click on the Filter icon (looks like a funnel) to show filter options.
  4. Select the item you would like to filter.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you apply filters in spreadsheets?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Anime about fantasy?

At myanimelist apply the filters for fantasy and browse through the database at your leisure.


How do you block emails with no subject in Gmail?

Unwanted mails are also known as SPAM. You can either delete them or apply filters. Filters are an easy way to block messages.


Is there a program available to block somes email address so they will know they are blockef?

You there is no program available for that. A person can apply filters on other's mails. These filters cannot be known by the other person.


Can you give me a particular system where I can apply Visual Basic Programming?

One common example is Microsoft 'Excel' - VBA is used for writing and editing macros in spreadsheets.


How old do you have be to connect your dsi to the internet?

There is no age limit, although parents may apply parental filters stopping you.


How do you clean dip well water?

Take a sample for a lab test to find what's in it first. People who apply common filters without knowing what analysis they have are wasting time and money.Take a sample for a lab test to find what's in it first. People who apply common filters without knowing what analysis they have are wasting time and money.


What is the difference between manual and electronic spreadsheets?

Manual spreadsheets are made with a pencil on paper. Electronic spreadsheets are made with a program on a computer.


Advantages and disadvantages of spreadsheets?

There are many advantages and disadvantages of using spreadsheets such as the fact that they are highly organized. One disadvantage of spreadsheets is that they can be complicated to understand.


What is tab in spreadsheets excel?

The tabs at the bottom of the screen identify individual spreadsheets.


Are spreadsheets or databases more powerful?

Databases are somewhat similar to spreadsheets, but databases are more powerful than spreadsheets because of their ability to manipulate the data.


How do you use smart filter in Adobe Photoshop cs3?

Click on layer (to which you want to apply smart filter) to select it in Layers palette then go to Filter > Convert For Smart Filters. After converting layer to Smart Object using Convert For Smart Filters command you can apply any of available filters completely non-destructive. Non-destructive means that you can always hide, change or remove filter even after saving and reopening PSD file.


What jobs use spreadsheets?

Certain people use spreadsheets in their jobs. Some of these people are:Accountants- they use spreadsheets in their jobs to work out formulas quickly and to keep recordsTeachers- use spreadsheets to keep track of children's progress and... Alot of other jobs involving numbersYou can use spreadsheets in almost any job.