Drop down fill box does not appear when cell clicked.

  • Thread starter JIM - Farmington, Utah
  • Start date
J

JIM - Farmington, Utah

I have created a fill in drop down boxes using the data validation tab in
excel 2007. Was working fine, but for reasons unknow all of the cells that
have data validation drop downs do not work. When clicking the cells the
drop down boxes do not appear. (The arrow that used to appear to the right
of the cell does not show.) All the setting are correct in the data
validation set-up. Data is validated per lists. Any thoughts as to why the
drop down arrow does not show any longer?
 
G

Gary''s Student

I have seen this once before. We had Data Validation pull-downs on a sheet
as well as some Shapes. We deleted all the Shapes and the pull-downs
vanished as well.

Deleting all Shapes also seems to kill the AutoFilter pull-downs.
 

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

DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Created invoices in Excel - not working in Drive 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Combo box 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Formatted cell column in drop down list 1
customize drop-down box 1

Top