How do I create a drop down box in a cell? I would like 2 drop down boxes
on a sheet, one to select a different sheet to get data from and another one
that simply has 3 options.
Thanks in advance,
Gary
How do I create a drop down box in a cell? I would like 2 drop down boxes
on a sheet, one to select a different sheet to get data from and another one
that simply has 3 options.
Thanks in advance,
Gary
Click on the cell, select
DATA>VALIDATION>LIST
Make sure "in-cell dropdown" is checked and put the source cells in the
SOURCE box.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks