✔ 最佳答案
Method 1:
1.Select the cell to be formulated
2.Choose data in menu bar
3.Select validation
4.Select tag “setting”, you will see validation criteria
5.At Allow: >> Select “List”
6.At Source: >> key in the data as you need and with “,” sign as a separator
7.And then click “OK”
Method 2:
1.Pre-define a list in any of your worksheet (better in a separate worksheet)
2.Select the cell to be formulated
3.Choose data in menu bar
4.Select validation
5.Select tag “setting”, you will see validation criteria
6.At Allow: >> Select “List”
7.At Source: >> go back to the worksheet with the pre-defined list and select the list area
8.End