edit a drop down list

G

Guest

Hello, I have 2 questions

1. for an existing drop down list, how can I add a new entry? That is, a
list named "division" now contains 5 items, and I want to add a sixth. I've
tried to highlight all 6 items and typing "division" into the name box, but
that just jumps me to the original 5 names. I also tried highlighting the
original 5 and deleting the "division" from the name box, but again no luck.

2. Can I enlarge the font on a drop down list, so it appears larger when
the arrow is clicked? The font is very small at present.
 
D

Debra Dalgleish

To change the name reference:

Choose Insert>Name>Define
In the list of names, select Division
In the Refers To box, change the reference, to include the new items
Click OK

If this is a data validation dropdown, you can't make the font larger,
but there are a couple of workarounds here:

http://www.contextures.com/xlDataVal08.html#Larger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
How to Update drop-down list? 5
Formatting a drop down list 2
Drop Down Problems 2
empty cells in the drop down list 7
drop down list should remember selection. 6
Drop-Down List 3
Drop down List Formatting 3

Top