The dropdown arrow is visible only when you select the cell.

Do you have "In-cell dropdown" selected?

Do you have ToolsOptionsViewObjects set for "Show All"?


Gord Dibben MS Excel MVP

On Tue, 2 Mar 2010 08:48:06 -0800, biggles592
wrote:

I have a range of cells that I have formatted using Data Validation to have
their contents limited to selection from a drop Down list. However the down
arrow at the right hand side of each cell is missing or not displayed. What
could be wrong please?