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

Theme images by 5ugarless. Powered by Blogger.