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.
② Click the A11 cell and click on the menu bar--data--valid.
③ 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.
⑤ok, set up, you can see A11 cell after the small triangle, click it can quickly enter the Xu Jiayin.