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

img1

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

img2

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

img3

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

img4

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

img5
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.

img6;

  • 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.

img7

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

img8

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

img9

img10

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

 

image 48

 

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

 

 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube