Selecting cells that only contain Text in Excel

To select specific cells that only contain text, we can use the Go-To option or Conditional Formatting in Excel.

Let’s take an example and understand how and where we can use these functions.

We have data in range A1:C10 which contains text and numbers. We need to select only those cells which contain text.

Lets see how we can use the Go-To Special option.

Go-To Special:- This option is used to quickly re-direct to different cells in Excel.

Shortcut: F5 and Ctrl+G

Command button: Go to Home>click on Find & Select >select Go to Special

Follow the below given steps:-

• Select the data A1:C10

• Press key F5 on the keyboard, the Go- To dialog box willappear.

• Click on “SPECIAL” button.
• The Go-to Special dialog box will appear.

• Click on “Constants”, the inactive links under Formulas will get activated.

• Now uncheck all the options except “Text” and click on OK, only the cells containing text will be selected.

Select the cells containing text by using Conditional Formatting.

• Select the data A1:C10
• Go to the Home tab> in the Styles group > select Conditional Formatting.
• Select New rule from the Conditional Formatting drop down menu.

;

• The New Formatting Rule dialog box will appear.
• Select “Use a formula to determine which cells to format”
• In the formula tab, write the TEXT function.
• =ISTEXT(A2:C10), click on “Format” button.

• The Format Cells dialog box will appear.
• Choose any color.

• Click on OK, Format Cells dialog box.
• Click on OK, New Formatting Rule dialog box.

These are the ways in which you can highlight the text contains cells in Microsoft Excel.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com