You can hide that arrow in the Data|Validation dialog.

On the Settings tab, you can choose List and see an optionbutton for:
In-Cell Dropdown

Is that checked?

This doesn't seem to fit--it would affect all the worksheets in that workbook,
but you may want to check anyway.

In xl2003:
Tools|Options|View tab|Objects section
make sure "show all" is checked


Varne wrote:

Hi

In the same workbook I have the above problem in one page only. Throughout
the page.

The cells get validated if validation is done manually or by macro. However
since there is no arrow a value from the list cannot be selected. Instead I
have key in a value within the list range.

If anyone has come across such a problem please reply.

Thanks

M Varnendra

--

Dave Peterson