Skip navigation

Using text filters

Using text filters: Excel 2016: Managing and Analyzing Data
Using text filters: Excel 2016: Managing and Analyzing Data

When filtering in a text column, options include: Equals, Does Not Equal, Begins With, Ends With, Contains, and Does Not Contain. Furthermore, as a substitute for Contains, you can type entries in the Search panel as the list below it shrinks as you type each additional character. Pressing OK reveals the filtered list.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
253,982
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now