| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i leave the arrow for the drop down list visible in Excel?
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i leave the arrow for the drop down list visible in Excel?
Hi,
No way I know of. Most people overcome this with some sort of cell shading to indicate the presence of a list. Mike "Cara86" wrote: 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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i leave the arrow for the drop down list visible in Excel?
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 On Wed, 6 Aug 2008 04:36:01 -0700, Cara86 <Cara86 @discussions.microsoft.com wrote: 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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation drop down arrow list disappeared | Excel Discussion (Misc queries) | |||
| Excel sheet: scroll down, but leave first lines visible | New Users to Excel | |||
| Excel drop down list arrow has disappeared. | Excel Worksheet Functions | |||
| Data Validation - Drop-down list - make arrow visible at all times | Excel Discussion (Misc queries) | |||
| excel 2003, ,,list drop-down arrow not visable | New Users to Excel | |||
Linear Mode
