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
- In the Go To dialog box, click on Special button
- In the Go To Special dialog box, select Constants. And check only Text
- Click OK.
Below are the examples that show how to select cells that only contain Number or Errors:
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
Now that you know these two nifty techniques and can play around with the options and get various desired results.
Happy Excelling… 🙂
Also read: