Why is data validation disabled in Excel?

Asked by Last Modified  

1 Answer

+1 Microsoft Excel Training

Follow 1
Answer

Please enter your answer

Hemant Parmar

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
Dislike Bookmark

Related Questions

which is the best college or institute for Data analysis course certificate with Fresher placement support in pune?
Hi.. There are the institutes conducting online courses. Like for example, Simplilearn Edureka. Particularly in pune, ExcelR* Hope it will helpful. *before joining compare with other institutes.
Priya
0 0
5
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V
Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Dharmendra
0 0
9
What is the use of Data validation commond. can you demonstare the example in common life?
The point of data validation is to pick the list in a drop down fashion. It will ease your work by allowing you to select the entries from the drop down rather than you writing for it. It saves a lot of time when it comes to large dataset.
Anil
0 0
5

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

Ask a Question

Related Lessons

Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...

Itech Analytic Solutions

0 0
0
How Lookup function to replace Nested If statement
Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh Chavan

0 0
0
Remove gridline on active sheet
If you want to remove gridline on your active work sheet then follow below path Go to Ribbon click on View tab then uncheck gridline check box as shown in picture

Shashank Maheshwari

1 0
0
Microsoft Outlook
Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring...

Itech Analytic Solutions

0 1
0
Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen Ma

0 0
0

Recommended Articles

Why Should you Become an IT Consultant

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 >

What is Applications Engineering all about?

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 >

Make a Career in Mobile Application Programming

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 >

Learn Microsoft Excel

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 >

Find MS Office Software Training near you
MS Office Software Training in Bangalore
MS Office Software Training in Hyderabad
MS Office Software Training in Delhi
MS Office Software Training in Mumbai
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Gurgaon
MS Office Software Training in Ahmedabad
MS Office Software Training in Noida

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