How to use the Excel2010 data validation function

How to use the Excel2010 data validation function

① or the old rules, first start Excel2010, input basic data, this time we want to use the data validity function to enter Evergrande Boss's name, enter other name to prompt error.

Excel2010

② Click the A11 cell and click on the menu bar--data--valid.

Excel2010

③ now set the label inside will allow to set as a sequence, and then in the following source to enter the name of Evergrande boss Xu Jiayin.

④ switch to the error warning label, style selected as warning, fill in the title and error message.

Excel2010

⑤ok, set up, you can see A11 cell after the small triangle, click it can quickly enter the Xu Jiayin.