![]() However, if you copy a cell with a value or formula they will be pasted along the drop down.īack to top How to deal with a workbook with multiple different lists Note: You can also do a regular Copy/Paste operation to paste the list. ![]() Right-click, select paste special, click on Validation and press OK.Select the cells where you want to paste the drop down list.Copy the cell by pressing Ctrl + C or Right-click -> Copy.Select a cell that contains the drop down list you want to copy.To create a list from a range in another worksheet, in the Data Validation dialog box press the range selection button, and go to the desired range in the other worksheet.īack to top How to remove drop down listsīack to top How to copy lists from one cell to another If you’re using Excel 2007 or later you can create a drop down from a source range that is located in another worksheet. Or it can be entered by selecting a range that contains the options you want in your list.īack to top Create lists using information from other worksheets ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |