This post will guide you how to select all cells with specific text in Excel. How do I select cells that contain specific characters in Excel. How to find and select cells that meet specific conditions in Excel.

Selecting Cells that contain specific text

---

Assuming that you have a list of data in a range A1:C4, and you want to find and select all cells that contain a specific text string, how to achieve it. You can use the Find and Select feature to select cells. Just do the following steps:

#1 go to HOME tab, click Find & Select command under Editing group. And the Find and Replace dialog will open.

#2 type one text string that you want to find in your data. Type “excel” text in the Find What list box.

#3 click Find All button. And all cells that contain “excel” text string have been searched.

#4 press Ctrl +A keys in your keyboard to select all searched values. Then click Close button.

#5 you will see all cells that contain “excel” text have been selected.