How do i leave the arrow for the drop down list visible in Excel?

  • Thread starter Thread starter Cara86
  • Start date Start date
C

Cara86

I have created many lists in Excel and the arrow for the list only appears
when i click on the list itself. How do make the arrow visible at all times,
so that others are aware that this is a list???
 
Hi,

No way I know of. Most people overcome this with some sort of cell shading
to indicate the presence of a list.

Mike
 
No way to do this.

Workaround is to color those cells so's they stand out.

Or use a ComboBox from the Control Toolbox or Forms Toolbar.

The Control Toolbox ComboBox would give more flexibility I believe.


Gord Dibben MS Excel MVP
 

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

alt down arrow shortcut not working 0
Usability - drop down box - Arrow INSIDE box? 1
drop downs showing down arrow 4
Drop down list question 1
How do i show the drop down arrow for a list in Excel 1
drop down Lists 2
Making Drop Down Box Visible with Excel 2003 2
Data Validation - Drop-down list - make arrow visible at all times 3

Back
Top