Allow Only the Specific Characters to be Entered in a Range of Cells in Excel!!
Tags: allowonlythespecific, kutoolsexceltutorial, kutools
Published: 2020-09-24 03:38:57

---
title: Allow Only the Specific Characters to be Entered in a Range of Cells in Excel!!
published: true
date: 2020-09-23 12:22:33 UTC
tags: AllowOnlytheSpecific,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/allow-only-the-specific-characters-to-be-entered-in-a-range-of-cells-in-excel/
---

## Allow Only the Specific Characters to be Entered in a Range of Cells in Excel:

Let’s see how to **Allow Only the Specific Characters to be Entered in a Range of Cells in Excel Office 365** using **Kutools**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Allow Only the Specific Characters to be Entered in a Range of Cells:

To prevent cells from entering various characters and at the same time, allow only the specific characters to be entered in a range of cells, do as below steps.

- **Select a column or a range of cells** to allow only the specific characters to be entered into them.

![Selected Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-96.png)<figcaption id="caption-attachment-14535">Selected Range</figcaption>

- Go to the **Kutools**  **Tab** , **select** the **Prevent Typing** option, and **choose** the  **Prevent Typing** option from the menu.

![Choose Prevent Typing option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Prevent-Typing-option.png)<figcaption id="caption-attachment-14536">Choose Prevent Typing option</figcaption>

- It will open the **Prevent Typing dialog**   **box.**
- Now, you need to **select Allow**  **to type in these chars** option under the **Define restrictions** section.
- Then, enter the characters which you want to insert into the selected cells or click the button to select the cell which contains the characters that you want to allow only to be inserted.
- You can **select the Case sensitive** option if you want the entered characters are case sensitive.

![Prevent Typing dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Prevent-Typing-dialog-box.png)<figcaption id="caption-attachment-14537">Prevent Typing dialog box</figcaption>

- Then, **click** the **OK** button. It will open the **Kutools for Excel dialog box**.
- This dialog box reminded you that the original data validation can be removed after applying this feature.
- You need to **click**  **Yes** to continue this process.

![Kutools for Excel dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Kutools-for-Excel-dialog-box-1.png)<figcaption id="caption-attachment-14538">Kutools for Excel dialog box</figcaption>

- After clicking the **Yes** button another prompt box will be popped out to tell you only certain characters are allowed to be entered in the selection.
- You have to **click** the **OK** button.

![Kutools for Excel](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Kutools-for-Excel.png)<figcaption id="caption-attachment-14539">Kutools for Excel</figcaption>

- Now, you can start entering the characters into the selected range.
- If you enter the characters other than the specified characters, it will show the warning message as shown in the below example.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-3.png)<figcaption id="caption-attachment-14540">Result</figcaption>

## Closure:

In the above article, you can understand how to **Allow Only the Specific Characters to be Entered in a Range of Cells in Excel Office 365** using **Kutools**. Give your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!