Excel Office 365 Data Validation Options – Simple Instructions!!
Tags: datavalidationoption, excelpreface, exceltutorials
Published: 2020-12-11 03:37:14

---
title: Excel Office 365 Data Validation Options – Simple Instructions!!
published: true
date: 2020-12-10 21:00:53 UTC
tags: DataValidationOption,ExcelPreface,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-data-validation-options/
---

In this guide, we will show you the simple instructions to use **Data Validation Options in Excel Office 365** with examples. With the data validation option, you can easily prevent cells. Let’s see the various options below!! 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)**
## Only Allow the Text Length less than 10 Characters in Cells:

- You need to **select** a **cell** or a **range.** Here, we select a **cell B2**.

![Select a cell](https://geekexcel.com/wp-content/uploads/2020/12/1-24.png)<figcaption id="caption-attachment-19335">Select a cell</figcaption>

- On the **Data tab, select** the **Data Validation** option in the **Data Tools** section.

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will display the **Data Validation Dialog Box.**
- You need to **select** the **Text length** using the drop-down option under the **Allow field.**
- Then, **select** the **less than** option under the **Data field.**
- Under **Maximum field – Enter** the **text length** value. Here, we enter **10**.
- Then, **hit** the **OK** button to close this dialog box.

![Data Validation Dialog Box](https://geekexcel.com/wp-content/uploads/2020/12/Data-Validation-Dialog-Box.png)<figcaption id="caption-attachment-19338">Data Validation Dialog Box</figcaption>

- Now, if you **enter more than 10 characters** in the selected cell, it will throw an error message as shown in the below image.

![Prompt box](https://geekexcel.com/wp-content/uploads/2020/12/Prompt-box.png)<figcaption id="caption-attachment-19339">Prompt box</figcaption>

## To Allow the Whole Number Between 0-9 in Cells:

- First, you need to **select** a **cell** or a **range** where you want to apply the data validation.
- Go to the **Data tab, select** the **Data Validation** option in the **Data Tools** section.

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will display the **Data Validation Dialog Box.**
- **Allow Drop-down list** – Here, you need to **choose** the **Whole number** option.
- **Data Drop-down list** – You need to **select** the **between** option.
- **Minimum** – In this box, you need to **enter** the value **0**.
- **Maximum** – Here, you need to **enter** the value **9**.
- Finally, **click** the **OK** button to apply the data validation.

![Click OK button](https://geekexcel.com/wp-content/uploads/2020/12/3-14.png)<figcaption id="caption-attachment-19342">Click OK button</figcaption>

## Allow Only Positive numbers in Cells:

- You need to **select** a **cell** or a **range** that you want to apply data validation.
- On the **Data tab, select** the **Data Validation** option in the **Data Tools** section.

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will display the **Data Validation Dialog Box.**
- **Allow Drop-down list** – Here, you need to **choose** the **Decimal** option.
- **Data Drop-down list** – You need to **select** the **greater than** option.
- **Minimum box** – In this box, you need to **enter**  **0**.
- Finally, **hit** the **OK** button to apply the data validation.

![Data Validation Dialog Box](https://geekexcel.com/wp-content/uploads/2020/12/4-14.png)<figcaption id="caption-attachment-19345">Data Validation Dialog Box</figcaption>

## Excel Error Alert:

- **Select** a **cell** or a **range** that you want to apply the data validation.
- On the **Data tab, select** the **Data Validation** option in the **Data Tools** section.

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will display the **Data Validation Dialog Box.**
- You need to **click** the **Error Alert tab,** then **enter** the **message** in the **Error**   **message** text box.
- Then, **click** the **OK** button.

![Click the OK button](https://geekexcel.com/wp-content/uploads/2020/12/5-12.png)<figcaption id="caption-attachment-19346">Click the OK button</figcaption>

- Hereafter, if you type any invalid data in that particular cell or range, you will see an error message.

## Input Message:

- To do this, you need to **select** a **cell** or a **range** that you want to apply the data validation.
- On the **Data tab, select** the **Data Validation** option in the **Data Tools** section.

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will open the **Data Validation Dialog Box.**
- You need to **click** the **Input Message tab,** then enter the message in the **Input message** box.
- Finally, **click** the **OK** button.

![Data Validation Dialog Box](https://geekexcel.com/wp-content/uploads/2020/12/6-12.png)<figcaption id="caption-attachment-19357">Data Validation Dialog Box</figcaption>

- Now, if that particular cell or range is active, it will display the input message as like below.

## Closure:

In this guide, you can clearly understand the steps to use **Data Validation Options in Excel Office 365** with examples. Leave your **worthwhile feedback** with us. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Merge Cells in Excel Office 365 – Simple and Quick Ways!!](https://geekexcel.com/wp-admin/post.php?post=19211&action=edit)
- [Excel Office 365 Rows – [Insert, Delete, Hide, Unhide]](https://geekexcel.com/wp-admin/post.php?post=19107&action=edit)