Using Microsoft Excel provider lists

Using filters to find providers

When you first open an Excel provider list, you'll see that the providers are organized alphabetically by provider name. But the list is set up with filters that you can use to refine your search.


For example, if you only want to see providers located in the town of Shrewsbury:

  1. Click the drop-down arrow at the right of the "City" column.
  2. From the list that appears, choose "Shrewsbury."

Filter the provider list by city


To remove the filter and to see the entire list of providers again:

  1. Click the drop down arrow at the right of the "City" column.
  2. From the list that appears, choose "(All)."
Remove filters to see the entire provider list

Using search to find a provider by name

 

  1. First, remove all your filters and make sure you're viewing the entire provider list. (See the instructions above.)
    TIP: If a filter is "turned on" for column, the arrow to the right of it will be blue.
  2. On your keyboard, press the "Ctrl" and "f" keys at the same time.
  3. In the box that pops up, type in the provider's name, then click the "Find Next" button.
  4. The screen will jump down to the first provider listing with that name. Continue to click "Find Next" to see other providers with that name.
Search the provider list by  name