![]() ![]() ![]() ![]() ![]() In the Data Validation dialog box, under the Settings tab, choose List from the Allow drop down list, and then enter this formula: =Namelist ( Namelist is the range name you are created in step1) into the Source text box, see screenshot:Ĥ. Then click a cell or range where you want to insert the drop down list, and click Data > Data Validation > Data Validation, see screenshot:ģ. Define a range name for your data list which will be created to drop down list, select the data list, and enter a range name into the Name Box, and then press Enter key, see screenshot:Ģ. Please do with the following step by step:ġ. In fact, you can create one drop down list, and then copy and paste it to multiple worksheets as you like. It may be easy for you to insert a drop down list in a worksheet, but, have you ever tried to insert this data validation to multiple sheets at once? In this article, I will talk about how to apply one data validation to multiple worksheets quickly and easily.Īpply data validation to multiple worksheets at once How to apply data validation to multiple sheets at once in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |