For example, to allow up to a certain number of characters, select Restrict data entry to text of a specified length.īox, select the type of restriction that you want. If you want to enter specific times, use the hh:mm time format.įor example, say you have cell E2 set up with a start time (8:00 AM), and cell F2 with an end time (5:00 PM), and you want to limit meeting times between those times then select For example, to allow times before a certain time of day, selectĮnter the start, end, or specific time to allow. Restrict data entry to a time within a time frame.īox, select the type of restriction that you want. For example, to set a time frame between today's date and 3 days from today's date, select You can also enter a formula that returns a date. For example, to allow dates after a certain day, selectĮnter the start, end, or specific date to allow.
Restrict data entry to a date within range of dates.īox, select the type of restriction that you want. , and then display the data validation cell as a percentage by selecting the cell and clicking To let a user enter percentages, for example 20%, selectīox, select the type of restriction that you want in theīox, enter the minimum, maximum, or specific value as a decimal, for example
For example, to set a maximum limit for commissions and bonuses of 6% of a salesperson's salary in cell E1, select You can also enter a formula that returns a number value. Restrict data entry to a decimal number within limits. To set a minimum limit of deductions to two times the number of children in that cell, select You can also enter a formula that returns a number value.įor example, say you're validating data in cell F1. For example, to set upper and lower limits, selectĮnter the minimum, maximum, or specific value to allow. Restrict data entry to whole numbers within limits.īox, select the type of restriction that you want. The following table lists other types of data validation and shows you ways to add it to your worksheets. Now, if the user tries to enter a value that is not valid, an Tab to customize the error message and to choose a Tab and customize a message users will see when entering data.Ĭheckbox to display the message when the user selects or hovers over the selected cell(s). Set the other required values based on what you chose for to restrict the cell to accept only time. to restrict the cell to accept only date. to restrict the cell to accept only decimal numbers. to restrict the cell to accept only whole numbers. Select the cell(s) you want to create a rule for.
0 kommentar(er)
