UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Data Validation In Excel

ITech Analytic Solutions
27/12/2017 0 0

MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry, you can display a custom message.

Validation Criteria To specify the type of data allowable in a cell or range, follow the steps below while you refer to which shows all three tabs of the Data Validation dialog box. Select the cell or range.

Choose Data » Data Tools » Data Validation. Excel displays its Data Validation dialog box having 3 tabs settings, Input Message and Error alert. Settings tab Here you can set the type of validation you need.Choose an option from the Allow drop-down list.The contents of the Data Validation dialog box will change, displaying controls based on your choice.

Any Value: Selecting this option removes any existing data validation.

Whole Number: The user must enter a whole number.For example, you can specify that the entry must be a whole number greater than or equal to 50.

Decimal: The user must enter a number. For example, you can specify that the entry must be greater than or equal to 10 and less than or equal to 20.

List: The user must choose from a list of entries you provide.You will create drop-down list with this validation. You have to give input ranges then those values will appear in the dropdown.

Date: The user must enter a date. You specify a valid date range from choices in the Data drop-down list. For example, you can specify that the entered data must be greater than or equal to January 1, 2013, and less than or equal to December 31, 2013.

Time: The user must enter a time. You specify a valid time range from choices in the Data drop-down list. For example, you can specify that the entered data must be later than 12:00 p.m.

Text Length: The length of the data numberofcharacters is limited. You specify a valid length by using the Data drop-down list. For example, you can specify that the length of the entered data be 1 a single alphanumeric character.

Custom: To use this option, you must supply a logical formula that determines the validity of the user’s entry alogicalformulareturnseitherTRUEorFALSE.

Input Message tab:

You can set the input help message with this tab. Fill the title and Input message of the Input message tab and the input message will appear when cell is selected..

Error Alert Tab:

You can specify error message with this tab. Fill the title and error message. Select the style of the error as stop, warning or Information as per you need.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

R and SAS
Want to know how to grow your business and tactics to be known before you start your business . Join the analytics class where you can draw inferences and also conclusion about the market and also how...

Shahid Hassan

0 0
0

Common MS Excel Shortcuts to make life easier!
Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...
S

Shruti S.

0 0
0

Rand() Function
Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: =RAND() Usage: RAND() function will returns a number between 0 and 1. For example, = RAND()...

Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more