How to select cells that only contain Text, Number or Error in Microsoft Excel

At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or lock cells by the data type for various other reasons.

Follow below steps to select cells that only contain Text:

  • Press F5 to access Go To window

How to Select Cells Containing Only Text or Number or Error01

  • In the Go To dialog box, click on Special button

How to Select Cells Containing Only Text or Number or Error02

  • In the Go To Special dialog box, select Constants. And check only Text

How to Select Cells Containing Only Text or Number or Error03

  • Click OK.

How to Select Cells Containing Only Text or Number or Error03a

Below are the examples that show how to select cells that only contain Number or Errors:

How to Select Cells Containing Only Text or Number or Error04

How to Select Cells Containing Only Text or Number or Error04a

How to Select Cells Containing Only Text or Number or Error05

How to Select Cells Containing Only Text or Number or Error05a

Bonus Tip:

Use formulas =ISTEXT() =ISNUMBER() =ISERROR() with Conditional Formatting to Highlight the cells that only contain Text, Number or Errors. Check this article for step by step guide to learn Conditional Formatting How to Highlight a Row in Excel Using Conditional Formatting

How to Select Cells Containing Only Text or Number or Error06 How to Select Cells Containing Only Text or Number or Error06a

Now that you know these two nifty techniques and can play around with the options and get various desired results.

Happy Excelling… 🙂

Also read:


1

No Responses

Show all responses

Leave a Reply