Case tutorial

① Start Excel2010, open the data table, select the A2:A7 area, and click the menu bar--Formulas--Name Manager.

Excel2010

② A new interface will pop up, click the New button, set a name, here we can just pick the name, OK.

Excel2010

③We can clearly see the name, value, reference position, range and remark information, and close the window.

Excel2010

④ Then select column E and click Data--Data Validity in the menu bar.

Excel2010

⑤Set as sequence in Allow, source = name, OK.

Excel2010

⑥The data validity is now set. Click the small triangle next to it to select column A data. If you want to set all data areas as optional, you can change the reference location to the data area in the third step.

Excel2010

The above is the entire content of the method of using Excel2010 name manager and data validity shared by the editor. I hope it will be helpful to everyone! For more exciting tutorials, please pay more attention to Huajun Software Park!