How to use data validation ? Google sheets

Показать описание

Hope you learned to create dropdown data validation list.
For more excel, google sheet videos subscribe to the channel.

#excel #exceltutorial #googlesheets #datavalidation #professional #skills #list #datavisualization #dropdownlist #datavalidationlist #freshers #learnexcel #freeexcelcourse #learnforfun #hr

Aruika

Рекомендации по теме

Комментарии

SO GLAD I SAVED YOUR VIDEO FROM LAST YEAR and the year prior. This was simple and straight to the point. I already had my sheet set but I had to readjust my "categories/data validation choices" and was lost as to how I did it a year ago. Thank you so much!

alicia-badgirlbalm

perfect! I logged into Google Sheets from last year and saw this new feature! Thank goodness b/c this is way easier than the other manual way I had been doing it.

alicia-badgirlbalm

excellent, thank you. it was just what I was looking for

manuelcama

Can we add range in data validation rule.
For example: if i apply a formula to add 5 to the input. Can we add a range in data validation rule. Like if i enter 7 it adds 5 or if i add 13 then it adds 5 and so forth. Not a fixed parameter but a range of number from 1-100

rohitsingh

Thank you ☺️, this video is really helped me

Hem

I have a doubt : can we have 2 values from the drop down for eg : I went out to buy vegetables and I want to keep track of them. I add potato now I can't add tomato to the cell I want to add multiple tags in the same cells

ishwarkokkili

2:22 what if the dropdown data validation is from a different google spreadsheet?

BangTons

I am facing a problem when selecting listed items.

In my list some items are with same words only extra at end

Eg. Bold, bolde, bolds

When I'm selecting from the drop-down list, if 1st selection is bolds 2nd is bold, then bold is not selecting, bolds is appearing.

Thankyou

dastapash

I have one data validation range I want to use and 3 different criteria ranges(located in three different columns). Is there any way to include all three criteria ranges to that one data validation range? I spent an hour trying to find a solution, but I have yet to find someone who has covered this specific situation. I would really appreciate some advice. Best regards!

jx-

can you make a google sheet for me i will pay you

Surya-aaa

I don’t like the new drop down look it looks childish

noturmomma

How to use data validation ? Google sheets

How to apply data validation to cells in Microsoft Excel

Advanced Excel - Data Validation and Drop-Down Lists

MS Excel - Data Validation

Create SMART Drop Down Lists in Excel (with Data Validation)

How to use data validation in Microsoft Excel

Excel Custom Data Validation (Use formulas to check for text, numbers & length)

Easy Dynamic Dependent Data Validation Two Ways

Create data validation list from Excel Table... the RIGHT WAY!

Data Validation and Consolidation with HiveMQ Data Hub

How to use Indirect Function in data validation in MS Excel 2013

Data Validation | Data Validation in Excel | Excel Tutorial Part 16

Excel Drop Down List Tutorial

Excel - Data Validation with the INDIRECT Function - Excel Advanced

What is Data Validation | Excel

Excel Create Dependent Drop Down List Tutorial

The Excel Lookup and Data Validation Functions

How to use Excel Data Validation to protect cells

Data Validation and Drop Down Lists With Vlookup Function | Excel Tutorial

Create Data Validation (Drop down list) || Excel Malayalam

Data Validation 1 - Create Drop Down Menus in Excel

VALIDATION RULES & TEXT IN ACCESS

How to use Excel data validation rules for date functions

How to create Excel data validation for unique values

How to Use Data Validation in Google Sheets