Why is data validation disabled in Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Corporate Excel Trainer - 20Years

Data validation restricts a user to enter values in a cell based on the rule applied by the owner of the sheet. This is used only for specific purposes for example, in Forms, in certain types of reports where you want standardised values to be entered in a range or a column to restrict user to enter...
read more
Data validation restricts a user to enter values in a cell based on the rule applied by the owner of the sheet. This is used only for specific purposes for example, in Forms, in certain types of reports where you want standardised values to be entered in a range or a column to restrict user to enter specific range of date, values, text and so on. Due to above reasonsthe data validation function can not be enabled on the entire worksheet by default. It needs to be used for specific cells or range andeach cell or range may have different rule of data validation. hope this helps. hemant parmar read less
Comments

Related Questions

How can we convert date into days for any year?
Enter the DATE Select the cell with the returned date. Click the Home tab. Click Format Cells: Number in the Number group.
Profile Photo
Sensoph
0 0
View Comments9
What is the major concepts Excel VBA Training teaches?
- Macro programming - The Basics of vba - Variables,constants - Data types - User defined types - Working with operators - Reserved words - Control flow statements (if if else multiple else if select...
Profile Photo
Jayant
Dear sir,how to convert number to text in excel by formula?
To get a range of time, you first need to convert the time in Text format and then merge them. You can use the following TEXT Formula: = TEXT( B4, “hh:mm” ) & ( ” – ”...
Profile Photo
BINAYAK
0 0
View Comments8
Hello, I would like to attend training for getting updated with the latest features in MS PowerPoint, can you suggest best online coaching for this?
If you are staying in mumbai I can help you. I was corporate,trainer of Microsoft. I taught more than 5000 professionals on MS products. If you are interested you can contact me.
Profile Photo
Naren
How to become an expert or tutor in UrbanPro ?
You need to register as tutor, and you can choose which skill you expert I mean which you want to teach and give all the information.
Profile Photo
Jenil

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Most important things to remember while doing VLOOKUP! (Donts..)
Make sure there are no unwanted or additional spaces in between the words or afterwards Example: Robert Smith_ Note: To show the additional spaces I have underlined the entire words. Don’t...
Profile Photo

Microsoft Power BI
Microsoft Power BI is a free, self-service business intelligence cloud service that provides non-technical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's...
Profile Photo

Top 30 formulas in Excel
Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite. Vlookup If Iferror Sum Count Sumif Countif CountA Index Match Left Right Mid Tri...
Profile Photo

Macro Recording
G

Gagan G.

0 0
View Comments0

Hidden Gems of MS Excel - Find Unique Records using Advance Filter
Want to find UNIQUE Values in a Dataset/Range? By using an Option that is Flexible and Quick. You should find the Advance Filter option helpful. Q) But, Advance Filter is used for filter-ing?A)...
Profile Photo

Recommended Articles

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you