How to Add Data Validation in Google Sheets in 4 Easy as Pie Steps

So Today we are going to talk about How to add Data Validation in Google Sheets. I will explain you Step-by-Step, I hope you read this till end. This is as easy as a pie.

How to add Dropdown in Google Sheets

What is Data Validation?

When you add Data Validation to it, a dropdown appears there and then you have to select one of the options there.

Example min 1

Steps on How to add Data Validation in Google Sheets

There are several steps to add Data Validation to Google Sheets. I will clarify you all the steps.

Step 1:- Create a Spreadsheet

  • Step 1:- Go to the Website of Google Docs Spreadsheet.
  • Step 2:- Click on Blank.
How to add Data Validation in Google Sheets

Step 2:- Select a Cell or Cell Range in where you want Dropdown

You have to select a cell range or a cell where you want to add Data Validation {Dropdown}.

Select a Cell Range min

Step 3:- Go to Data Tab

You have to go to the Data Tab and then click on Data Validation.

Also Read :-

Want to Create a Facebook Page and Earn Money
Setect the Data Tab min

Step 4:- Add Data Validation

A dialog box will appear and there you have to do the following settings.

Step 1:- Select the option – List of Items

Step 1 Select the option List of Items min 1

Select the option of List of Items. This option means that you are adding some text to your Dropdown.

Step 2:- Add Text to the box & Save

Step 2 Add Text to the box min

Now you have to enter what text you want in your Dropdown.

After entering this Click on the Save📩 Button.

Data Validation Created !!

Your Data Validation is Created !! A dropdown will appear on the selected cells.

Data Validation Created min

I hope now you will able to know How to add Data Validation in Google Sheets.

How to Add Data Validation in Numbers

There is also an option to add Data Validation in Numbers. I will describe you this also Step-by-Step.

Step 1:- Select the option- Number

Step 1 Select the option Number min

You have to select Number Option.

Step 2:- Enter your Range of Numbers & then Save.

Also Read:-

Want to become a Computer Expert?
Step 2 Enter your Range of Numbers min

You have to enter a range from which Number to which Number you want Dropdown. After you enter your Range you have to click on Save.

Data Validation in Numbers Created !!

Also Read:-

Want to Create Instagram Page?

Data Validation in Numbers is Created !! Here a Dropdown will not appear but if you write a Number beyond the Range Error will be there like this.

Data Validation in Numbers Created min

Conclusion

I am very sure that you will be now able to know How to add Data Validation in Google Sheets. Share this Knowledge with your friends and then they can also know. If any help needed on How to add Data Validation in Google Sheets then you can comment in the Comment Section or you can “Chat with Sikho Tech” on Messenger and Sikho Tech will reply to you as “Soon as Possible.”

Get the Free E-Book Now !!

This E-Book includes:-
What is a Domain?
What is a Hosting?
What is C-Panel?


e bOOK 1
Default image
Dhairya Sommanek
Dhairya Sommanek is the Author and Founder of Sikho Tech. He is Blogger & a Digital Marketer. He has info about Computer which he would Like to Share it with You.
Articles: 8

2 Comments

  1. Aap content writing kaise karte he please is par ak blog banaiye.

Leave a Reply

close