Back to Blog
Microsoft excel data analysis tab7/6/2023 Step 3: Select equal to from the data list drop-down. Step 2: Click on the data validation tool from the Data Menu Bar and select Text Length in Allow drop-down. Step 1: Select B5 Cell from Example 2 Sheet. We can restrict a user to enter a limited text. Now Enter 11 in cell B2- It will throw by default error.Įxample #2 – Set Input Message and Error Alert Now Enter 1 in cell B2- It will allow a user to enter any whole number from 0 to 10. Step 3.4: All settings will apply to the selected cell. Step 3.3: Select between from the drop-down of the Data list, Enter the Minimum and Maximum number for restriction. Step 3.2: Select the Whole number, then Some more required options will be enabled. ![]() ![]() Step 3.1: On the Settings tab, Click on Allow drop-down under validation Criteria. Step 3: A data validation Pop-Up will open: Step 2: Go to the Data tab, click on Data Validation from Data in the toolbar.
0 Comments
Read More
Leave a Reply. |