![]() ![]() Create a drop-down list with color - Microsoft Excel in Mac On a new worksheet, type the values that you want to appear in your drop-down list. ![]() The same list data was put into the range J1:J6, then I changed the source reference to these cells. A better way is to put the list in a range, then refer to the range. Manually entering the source data for the Excel 2010 drop down list is probably the least desirable method. Less You can help people work more efficiently in worksheets by using drop-down lists in cells where they can pick an item from a list you create.
0 Comments
Leave a Reply. |