Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Filter Text in Excel 2013

In this video you’ll learn how to filter text in Excel. This is a useful tool for grouping cells that contain the same text values together.

Begin by select a range of cells that contain the text you want to filter.
Go to the Data tab.
Go to the Sort & Filter group.
Click Filter.
Notice that an arrow appears in the column header.
Click the arrow.
Select a text value from the list.
Select Text Filters.
Click Custom Filter.
To find all cells that contain a word, select Contains.
If you only want to find cells that begin with a certain letter, select Begins With.