Hi Jenny,
I can definitely help you with that! Making the drop down arrow visible in a cell is a great way to make it clear to users that there is a drop down list available. Here's how you can do it:
- Select the cell or cells where you have created the drop down list.
- Click on the "Data Validation" button in the "Data" tab of the ribbon.
- In the "Data Validation" dialog box, go to the "Settings" tab.
- In the "Allow" dropdown menu, select "List".
- In the "Source" field, enter the range of cells that contain the items you want to appear in the drop down list. For example, if your list is in cells A1:A5, you would enter .
- Check the box next to "In-cell dropdown".
- Click "OK" to close the dialog box.
Now, the drop down arrow should be visible in the cell or cells you selected. When a user clicks on the arrow, they will see the list of items you specified in the
"Source" field.