Prevent Special or Certain Characters From Being Typed in Cells in Excel!!
Tags: kutoolsexceltutorial, preventspecialorcert, kutools
Published: 2020-09-25 03:45:23

---
title: Prevent Special or Certain Characters From Being Typed in Cells in Excel!!
published: true
date: 2020-09-24 11:55:59 UTC
tags: KutoolsExcelTutorial,PreventSpecialorCert,Kutools
canonical_url: https://geekexcel.com/prevent-special-or-certain-characters-from-being-typed-in-cells-in-excel/
---

## Prevent Special or Certain Characters From Being Typed in Cells:

In this article, we are going to see how to **Prevent Special or Certain Characters From Being Typed in 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.

## Prevent Typing in Any Special Characters:

Here are the steps to prevent typing in any special characters, do as follows.

- First, you need to **select a cell or range of cells** that you want to prevent special characters from being typed in.

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

- On the **Kutools**  **Tab** , **choose** the **Prevent**  **Typing** option, then **select**  **Prevent**  **Typing** option from the drop-down menu.

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

- It will open the  **Prevent**  **Typing dialog box**.
- You have to **check Prevent type in the special characters** option under the **Define restrictions** section.
- Then, **click** the **OK** button.

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

- After clicking the OK button, it will open the **Kutools for Excel dialog box. ** This dialog box will remind you that it will remove the data validation if you apply this feature.

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

- You need to **click**  **yes** to continue this process. It will open the prompt box to tell you how many cells have been prevented.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/5-10.png)<figcaption id="caption-attachment-14566">Click OK button</figcaption>

- You have to **click** the **OK** button and start typing the characters.
- If you enter any special characters, it will show you a warning message as shown in the below screenshot.

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

## Prevent Typing in Certain Characters:

To prevent typing in certain characters in a particular cell or range, follow the below instructions.

- You need to select a range or column that you want to prevent certain characters from being typed in.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/7-6.png)<figcaption id="caption-attachment-14569">Select a range</figcaption>

- On the **Kutools**  **Tab** , **choose** the **Prevent**  **Typing** option, then **select**  **Prevent**  **Typing** option from the drop-down menu.

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

- It will open the  **Prevent**  **Typing dialog box**.
- You have to **check** the **Prevent type in these chars** option and enter the characters that you want to prevent typing in the cells in the given text box under the **Define restrictions** section.
- If you want to prevent characters in a case-sensitive manner, then **check** the **Case**  **sensitive** option and click the **OK** button.

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

- Now, **Kutools for Excel** dialog box will be popped out to tell you that it will remove the data validation if you apply this feature.

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

- You have to **click Yes** to continue this process.
- After clicking the Yes button, a prompt box will open to tell you that the selection has been prevented from entering specific characters. **Click OK** to close this box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/10-1.png)<figcaption id="caption-attachment-14572">Click the OK button</figcaption>

- Now, you will start entering the letters in the range.
- If you enter any characters other than the specified characters, it will show you a warning message as shown in the below screenshot.

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

## A Short Synopsis:

In the above article, you can clearly understand the steps to **Prevent Special or Certain Characters From Being Typed in Cells** in **Excel Office 365** using **Kutools**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!