Create, edit, or delete a custom user view in Office 365

If you're a global or user management admin of Office 365, you can create custom user views to view a specific subset of users. These views are in addition to the standard set of views that come with Office 365. You can create, edit, or delete custom user views, and the custom views you create are available to all admins.

Custom user views in the admin center

Use the new admin center to see custom user views

The new admin center is available to all Microsoft 365 admins. You can opt in by selecting the Try the new admin center toggle located at the top of the Home page. For more information, see About the new Microsoft 365 admin center.

When you create, edit, or delete a custom user view, the changes will be shown in the Filter list that all admins in your company see when they go to the Users page. You can create up to 50 custom views.

Use the old admin center to see custom user views

When you create, edit, or delete a custom user view, the changes will be shown in the Views list that all admins in your company see when they go to the Users page. You can create up to 50 custom views.

Tip

Standard user views are displayed by default in the Filters drop-down list. The standard filters include All users, Licensed users, Guest users, Sign-in allowed, Sign-in blocked, Unlicensed users, Users with errors, Billing admins, Global admins, Helpdesk admins, Service admins, and User management admins. You can't edit or delete standard views.

A few things to note about standard views:

  • Some standard views display an unsorted list if there are more than 2,000 users in the list. To locate specific users in this list, use the search box.
  • If you didn't purchase Office 365 from Microsoft, Billing admins don't appear in the standard views list. For more information, see Assigning admin roles.

Choose the filters for your custom user view

You can create and edit your custom views in the Custom view pane. (In the new admin center, this is called the Custom filter pane.) If you select multiple filter options, you get results that contain users who match all the selected criteria. The following example shows you how to create a custom view named "Canadian users" that shows all users on a specific domain who are in Canada.

A - Domain If you have multiple domains for your organization, you can choose from a drop-down list of domains that are available.

B - Sign-in status Choose users that are allowed or blocked.

C - Location Choose a location from a drop-down list of countries.

D - Assigned product license Choose from a drop-down list of licenses that are available at your organization. Use this filter to show users who have the license you selected assigned to them. Users may also have additional licenses.

You can also filter by additional user profile details used in your organization such as department, city, state or province, country or region, or job title.

Other conditions:

  • Synchronized users only Select this box to show all users who have been synced with the local Active Directory, regardless of whether the users have been activated or not.

  • Users with errors Select this box to show users who may have provisioning errors.

  • Unlicensed users Select this box to find all the users who haven't been assigned a license. The results for this view can also include users who have an Exchange mailbox but don't have a license. To track those users specifically, use the filter Unlicensed users with Exchange mailboxes or archives. The results for this view can also include users who have an Exchange archive, but don't have a license.

  • Unlicensed users with Exchange mailboxes or archives Select this box to show user accounts that were created in Exchange Online and have an Exchange mailbox, but weren't assigned an Office 365 license. The results of this filter include users who have or who were assigned an Exchange archive.

Tip

If you create a custom view that returns more than 2,000 users, the resulting user list isn't sorted. In this case, use the search box to find users or edit your custom view to refine your search.

Create a custom user view

Use the new admin center to create a custom user view

The new admin center is available to all Microsoft 365 admins. You can opt in by selecting the Try the new admin center toggle located at the top of the Home page. For more information, see About the new Microsoft 365 admin center.

  1. In the admin center, go to the Users > Active users page.

  2. On the Active users page, select Filters and select New filter.

  3. On the Custom filter page, enter the name for your filter, choose the conditions for your custom filter, and then select Add. Your custom view is now included in the drop-down list of filters.

Use the old admin center to create a custom user view

  1. In the admin center, go to the Users > Active users page.
  1. In the admin center, go to the Users > Active users page.
  1. In the admin center, go to the Users > Active users page.
  1. On the Active users page, select Views and select Add custom view.

  2. On the Custom view page, enter the name for your filter, choose the conditions for your custom filter, and then select Add. Your custom view is now included in the drop-down list of filters.

Edit or delete a custom user view

Use the new admin center to edit or delete a custom user view

The new admin center is available to all Microsoft 365 admins. You can opt in by selecting the Try the new admin center toggle located at the top of the Home page. For more information, see About the new Microsoft 365 admin center.

  1. In the admin center, go to the Users > Active users page.

  2. On the Active users page, select Filter, select the filter you want to change, and then select Edit filter.

    Tip

    You can edit only custom views.

  3. On the Custom filter page, edit the information as needed, and then select Save. Or, to delete the filter, at the bottom of the page select Delete.

Use the old admin center to edit or delete a custom user view

  1. In the admin center, go to the Users > Active users page.
  1. In the admin center, go to the Users > Active users page.
  1. In the admin center, go to the Users > Active users page.
  1. On the Active users page, select Views, select the filter you want to change, and then select Edit this view.

    Tip

    You can edit only custom views.

  2. On the Custom view page, edit the information as needed, and then select Save. Or, to delete the filter, at the bottom of the page select Delete custom view.