![msd graph view table of contents in word msd graph view table of contents in word](https://i0.wp.com/farm8.staticflickr.com/7447/9928879974_9dfd6d94d3_b.jpg)
Step 2: Select custom in Allow drop-down.
![msd graph view table of contents in word msd graph view table of contents in word](https://els-jbs-prod-cdn.jbs.elsevierhealth.com/cms/attachment/d5faca6a-5c8b-4a0d-8438-c1e1677b6492/gr1.jpg)
Step 1: Select the C2 cell, Go to Data Tab and click on Validation data in the toolbar. It will throw the described error message.Įxample #3 – Custom option for e-mail address validation On the Selection of Cell, an Input message will be displayed.Įnter a text which has a text length of 11. Step 7: After that, click the Ok button, the setting will be applied to the selected cell. Step 6: Click on the Error Alert tab, provide a Title and the Error message, which will be displayed if a user entered an invalid length password. Step 5: Click on the Input Message tab and provide a message displayed on the selection of cell.
Msd graph view table of contents in word password#
Step 4: Enter your desired length of the password (as an example 11). 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.