Restricting Cell Entries to Text Only in Microsoft Excel 2010

In this article we will learn how to restrict cell entries to text only in Microsoft Excel 2010.

While working on reports, you may want to prevent the users from entering any value other than text. To prevent users from entering numbers in a cell, we will use Excel’s built in feature Data Validation.

Let us take an example:

In column A, we want to ensure that only text can be entered into the cells.To prevent the users from entering numbers in column A.

  • Select column A.
  • Click on Data ribbon
  • In Data Tools group, click on Data Validation

img1

  • The Data Validation dialog box will appear

img2

  • In Settings tab, select Custom in Validation criteria & enter the formula as =ISTEXT(A1) in Formula box

img3

  • The above mentioned formula will prevent the users from entering digits as it will allow the user to enter only text in column A.
  • Click on OK
  • If we enter text then Excel will allow us while if we try to enter the numbers then it will display an error message

img4

  • In above shown screenshot, cell A1 contains https://www.exceltip.com/tipswhich is a text, and Data Validation feature will allow to enter any text if we try to enter a number in cell A3 then it will not be allowed & an error message will pop-up.

Using Excel’s built in feature Data Validation, we can make customized reports for the end user to enter the information that we are looking for.

 

Users are saying about us...

  1. Hi Basavaraj,

    Alphanumeric characters are considered to be Text.
    Please try to follow the steps shown in the tutorial & you will not face any issue.

    Thanks & Regards,
    Ashish

    • Ashish – you rudely admonish the Basavaraj to: “Please try to follow the steps shown in the tutorial & you will not face any issue.”
      Well, you &$%#, if YOU ‘tried to follow the steps shown’ ….
      it SAYS – DIRECT QUOTE : (with my EMPHASIS)
      ” … Data Validation feature will allow to enter any text IF WE TRY TO ENTER A NUMBER IN CELL A3 THEN IT WILL NOT BE ALLOWED & an error message will pop-up.

      ASL ?

Leave a Reply to eric Cancel 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