Data validation on excel sheets | MS_Excel Bangla Tutorial | BASAR360XL
Data validation on excel sheets
Add data validation to a cell or a range
- Select one or more cells to validate.
- On the Data tab, in the Data Tools group, click Data Validation.
- On the Settings tab, in the Allow box, select List.
- In the Source box, type your list values, separated by commas. ...
- Make sure that the In-cell dropdown check box is selected.
No comments