drop down menu issue

Microsoft Office excel 2007 - upgrade
May 5, 2010 at 06:09:51
Specs: Macintosh
I am using cell validation to make a drop down menu from a range of cells on another sheet. I have selected the cells on that sheet and given them a name "x". Within "x" are say 5 cells directly below each other. Now when I validate the list to show "x" only the first 3 entries appear. It doesn't matter how many cells are in the list, only the first 3 appear on the drop down.

Can anyone help with this?

See More: drop down menu issue

May 5, 2010 at 08:59:14
Since I can't see your spreadsheet from where I'm sitting, all I can ask is this:

Are you sure that the Named Range "x" actually refers to all of the cells that you want in the list?

Go to Insert..Name...Define and click on the "x".

Does it refer to your full list?

Report •
Related Solutions

Ask Question