Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Filtering data in Microsoft Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Filtering data in Microsoft Excel

One of the more useful functions in Excel, which you can use to filter and display only the data you are interested in.

 
  Author: mat | Version: 2010 | 6th January 2012 |  
 
 
1.
 

Open a new data sheet and enter data similar to mine.

You can of course use one of your existing data sheets.

 
 
2.
 

Select  the title cells (see picture).

 
 
3.
 

Click the Data tab ...

 
 
4.
 

... and click Filter button.

 
 
5.
 

Excel created the filters  automatically for each column automatically.

Let's check out how this thing works.

I want to display data only for London, so I need to click City (see picture) ...


 
 
6.
 

... and select only London (see picture).

Click OK.

 
 
7.
 

And now there are only rows with London displayed, just like I wanted to.

 
 
8.
 

Let's bring back all the cities again.

Click City and (Select All) option.

 
 
9.
 

Now let's do something else, I want to display only the rows where the costs are larger then 200$.

I need to click the Cost filter, Number Filters and choose Greater Than...

 
 
10.
 

In the Custom AutoFilter window choose is greater than and enter 200.

Click OK.

 
 
11.
 

Now I can only see the rows where the Cost is larger than 200$.

Would you know how to display only the people who live in London and their costs are greater then 200$?

 
 
 
   
  Please login to post a comment
  Click to open user profile  
ahr147, 23rd Jun 2025, 8:45 AM
https://www.anysvape.com/拋棄式一次.... 一次性小煙https://www.anysvape.com/拋棄式一次.... iqos 電子煙​https://www.anysvape.com/拋棄式一次.... 拋棄 式 電子 菸​https://www.anysvape.com/拋棄式一次.... 電子 菸 推薦https://www.anysvape.com/Relx relx 電子菸https://www.anysvape.com/Relx 悅刻電子菸https://www.anysvape.com/Relx 悅刻官網https://www.anysvape.com/Relx relx 官網https://www.anysvape.com/Relx 悅刻門市https://www.anysvape.com/Relx RELXhttps://www.anysvape.com/Relx 電子 菸https://www.anysvape.com/Relx relx 台北https://www.anysvape.com/Relx relx podhttps://www.anysvape.com/Relx 悅刻煙彈https://www.anysvape.com/煙彈大全 煙 彈https://www.anysvape.com/煙彈大全 LANA煙彈https://www.anysvape.com/煙彈大全 sp2s 煙 彈​https://www.anysvape.com/煙彈大全 悅刻6代煙彈https://www.anysvape.com/煙彈大全 relx 煙彈https://www.anysvape.com/煙彈大全 電子 菸 油https://www.anysvape.com/煙彈大全 空倉https://www.anysvape.com/煙彈大全 空彈https://www.anysvape.com/LANA拉娜 LANA煙彈https://www.anysvape.com/LANA拉娜 LANA 電子 菸​https://www.anysvape.com/LANA拉娜 LANA 各式煙彈https://www.anysvape.com/LANA拉娜 LANA主機https://www.anysvape.com/SP2S思博瑞 sp2s 煙 彈​https://www.anysvape.com/SP2S思博瑞 思博瑞https://www.anysvape.com/SP2S思博瑞 sp2s主機https://www.anysvape.com/SP2S思博瑞 sp2s電子煙https://www.anysvape.com/SP2S思博瑞 SP2S PRO電子煙https://www.anysvape.com/SP2S思博瑞 sp2s 一次性https://www.anysvape.com/ILIA哩亞 ILIAhttps://www.anysvape.com/ILIA哩亞 哩亞https://www.anysvape.com/ILIA哩亞 ILIA主機https://www.anysvape.com/ILIA哩亞 哩亞主機https://www.anysvape.com/ILIA哩亞 ILIA電子煙https://www.anysvape.com/ILIA哩亞 ILIA 一次性https://www.anysvape.com/SHAXIAO系列 SHAXIAOhttps://www.anysvape.com/SHAXIAO系列 殺小https://www.anysvape.com/SHAXIAO系列 殺小主機https://www.anysvape.com/SHAXIAO系列 SHAXIAO電子煙https://www.anysvape.com/SHAXIAO系列 SHAXIAO 一次性https://www.anysvape.com/XIAOKE系列 XIAOKEhttps://www.anysvape.com/XIAOKE系列 梟客https://www.anysvape.com/XIAOKE系列 梟客主機https://www.anysvape.com/XIAOKE系列 XIAOKE主機https://www.anysvape.com/XIAOKE系列 梟客電子煙https://www.anysvape.com/XIAOKE系列 XIAOKE 一次性https://www.anysvape.com/DIYA系列 DIYAhttps://www.anysvape.com/DIYA系列 叮啞https://www.anysvape.com/DIYA系列 DIYA一次性https://www.anysvape.com/DIYA系列 DIYA主機https://www.anysvape.com/DIYA系列 DIYA電子煙https://www.anysvape.com/换彈式主機 VAPEhttps://www.anysvape.com/换彈式主機 zero 電子 菸https://www.anysvape.com/换彈式主機 台灣 電子 菸https://www.anysvape.com/换彈式主機 美國 電子 菸https://www.anysvape.com/换彈式主機 pod vapehttps://www.anysvape.com/换彈式主機 vape in taiwanhttps://www.anysvape.com/换彈式主機 vape juice
 
 
  Click to open user profile  
ahr147, 23rd Jun 2025, 8:46 AM
http://www.relxh.com/relx 電子菸 relxhttp://www.relxh.com/relx relx 電子菸價格http://www.relxh.com/relx relx 電子菸台灣http://www.relxh.com/relx 電子菸主機http://www.relxh.com/relx 悅客電子菸http://www.relxg.com/relx relx 煙彈口味推薦http://www.relxg.com/relx relx 煙彈哪裡買http://www.relxg.com/relx 悅刻煙彈口味http://www.relxg.com/relx relx 煙彈購買http://www.relxg.com/relx relx 煙彈台灣https://www.twvape.top/2025%e5%8f%b0%e7%.... 2025台灣VAPE選購攻略:RELX 6代煙彈×殺小主機實測解析
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO