Drop Down List not Appearing

  • Thread starter Thread starter John
  • Start date Start date
J

John

I'm having a problem in a worksheet where a cell that has Data Validation
using a Drop down list is not appearing. The check box is ticked beside 'in
cell drop down'. I am using Excel97 and the Worksheet is protected. The cell
where the Drop down should be is not locked so I'm a bit lost

Any ideas?

Thanks
 
Are objects visible?

To make them visible, choose Tools>Options
 
Excel 97 also had a problem showing DV drop-down arrows when Window>Freeze
Panes was enabled.

Anything above the "freeze line" would be hidden.

Gord Dibben Excel MVP
 
Thanks Gird, that seems to be the reason


Gord Dibben said:
Excel 97 also had a problem showing DV drop-down arrows when Window>Freeze
Panes was enabled.

Anything above the "freeze line" would be hidden.

Gord Dibben Excel MVP
Click to expand...
 
You must log in or register to reply here.

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

Formatted cell column in drop down list 1
customize drop-down box 1
Drop down fill box does not appear when cell clicked. 1
Created invoices in Excel - not working in Drive 1
Displaying drop down list arrows 2
Create a drop-down list from a range of cells 2
Vlookups not working 2
excel 2003 drop-down box color changes how 2

Back
Top