The data validation in Excel provides a way of limiting the mistakes from the user and collecting valid data from the user. Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. The above date validation will only accept date values between 9th Nov 2020 to 18th Nov 2020.
Decimal - The user must enter a number with decimal values.For example, you can specify that the user must enter the number between 0 to 30. Whole Number - It allows only whole numbers.Any Value - It removes any existing data validation.There are eight options available to validate for user input: If you need to you can perform more advanced sorting methods in Excel by clicking the button to the right of the two small sort buttons in the ribbon menu.The settings tab is where you enter the validation criteria. Also, this method is a very quick way to sort your data alphabetically or numerically. Excel doesn't care if you have headers but it will try to determine on its own whether or not your data does contain headers. Note: You may or may not have headers for your data. OR Click "ZA" to put the list or data set in reverse alphabetical order or in numerical descending order so that the highest values are at the top of the list.Click "AZ" to put the list or data set in alphabetical order or in numerical ascending order so that the lowest values are at the top.Select a cell within the data set which you would like to sort.Steps to Sort Data Alphabetically or Numerically in Excel 2007: Basically, this is sorting data forwards and backwards. The sort feature in Excel allows you to very quickly sort any data set alphabetically and also numerically. This is a great feature to use when analyzing and organizing large sets of data and it can help to make sense out of all of that data.
This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007.