Mise à jour COVID-19

BO est en train de recruter et de déployer des bénévoles pour répondre aux besoins en matière de bénévolat liés spécifiquement à la COVID-19 à Ottawa, à Prescott-Russell, dans le comté de Lanark et dans le comté de Renfrew tout en assurant des protocoles de dépistage et de formation appropriés pour protéger la santé des bénévoles et de ceux qu'ils aident. Veuillez trouver les portails d'accueil des bénévoles, des membres et des autres organisations sur notre page d'accueil. BO remercie chaleureusement Centraide de l’Est de l’Ontario, la Ville d'Ottawa et la Fondation communautaire d'Ottawa pour leur soutien financier.

Espace Membres Événements English | Français Panier
Skip to main content
Inside Banner

Blog > Finding Data in Excel

Finding Data in Excel

affiché le 16 août 2018

Excel is a great tool for managing data, defined as “facts and statistics collected together for reference or analysis.” [1] Data can be numbers or text. Numbers can tell how much or how many, measure cost, or indicate the date and time. Text can be short codes, full words, phrases, addresses, phone numbers – basically, anything which can’t be counted is text.

Find Data: One at a Time

To find a specific piece of data, e.g. a person's name, click anywhere in your sheet, then click CTRL-F. Enter in the number or text you want to look for.

Note that Excel defaults to finding any cell which contains that number or text anywhere in the cell. For example, if you search for "Toronto", you will also be sent to cells which contain "Metro Toronto," "Greater Toronto Area," "Torontonian," etc.


Click Find Next to find the first cell which contains that data. Keep clicking to find subsequent cells.


Alternately, if you want to know the locations of all cells containing that data, then click Find All.


Find Data using Filters

Excel has an Auto-Filter which is likely to do a lot of what you need, with just a couple of clicks.

1. Select your header row. Note that you can only select ONE row.


2. Click Data → Filter


3. Now you will see drop-down arrows appear next to every header. Click on one of the drop-downs. (in the example, I clicked the “province” dropdown)


(a) You can sort the table by this column. Click one of the top three choices.

(b) You can select or deselect any values. Say you want to see everyone who is based in BC. Click Select All to deselect the whole list, then click BC.



(c) Let’s say you want to find out who in your list has a Hotmail account. You can use text filter to find that out. Click the Email dropdown, then Text Filters.


To find everyone with a Hotmail account, you want to find every cell in the Email column which contains the word Hotmail.


Note that we now have two filters: BC and Hotmail. You can see which columns are filtered because they have a filter icon in the dropdown box.


To remove a filter, click the dropdown for that column and click Select All.

If you have a lot of filters which you want to reset all at once, the easiest way is to click Data → Filter to toggle the filtering off. Then go back to step one if you want to start filtering afresh.

The filter function can also be used to sort data. See our previous blog post to learn more about data sorting.

Click here to register Tuesday, September 10, 2019. 9:00 a.m. to 12:00 p.m.

Want to learn more? Come to an upcoming workshop.

Click here for more information, and to register.

Volunteer Ottawa offers a comprehensive suite of courses related to all aspects of running a non-profit or a charity. Click here for our event calendar. Subscribe to our Event RSS Feed to be among the first to know when a new workshop is added to the schedule.

Like what you've read? Subscribe to our RSS feed so you never miss a post! We have a general RSS Feed for all VOices blog posts, as well as an Operations RSS Feed which will focus on topics related to organizational operations.

Related Blog Posts:


Filed under: Operations
new comment commentaire