Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying arrow in a dropdown list within cell
I created a dropdown list in Excel 2007 using the 'Data Validation' function.
I checked off 'In-cell dropdown' and finish process. However, whenever I clicked in the cell where I created the dropdown list, the dropdown arrow displays in the next cell to the right. This blocks the view o fthe contents of that cell. My question: How to display the arrow of a dropdown list within cell I created the dropdown? Thanks, Lionheart |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying arrow in a dropdown list within cell
You can't using a DV drop down list. Thats just how it works.
You can widen the column to the right so the arrow doesn't obscure the data in that cell. -- Biff Microsoft Excel MVP "Lionheart" wrote in message ... I created a dropdown list in Excel 2007 using the 'Data Validation' function. I checked off 'In-cell dropdown' and finish process. However, whenever I clicked in the cell where I created the dropdown list, the dropdown arrow displays in the next cell to the right. This blocks the view o fthe contents of that cell. My question: How to display the arrow of a dropdown list within cell I created the dropdown? Thanks, Lionheart |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying arrow in a dropdown list within cell
You can widen the column to the right so the
arrow doesn't obscure the data in that cell. You would also need to make sure the data in the adjacent column is aligned to the right or centered. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... You can't using a DV drop down list. Thats just how it works. You can widen the column to the right so the arrow doesn't obscure the data in that cell. -- Biff Microsoft Excel MVP "Lionheart" wrote in message ... I created a dropdown list in Excel 2007 using the 'Data Validation' function. I checked off 'In-cell dropdown' and finish process. However, whenever I clicked in the cell where I created the dropdown list, the dropdown arrow displays in the next cell to the right. This blocks the view o fthe contents of that cell. My question: How to display the arrow of a dropdown list within cell I created the dropdown? Thanks, Lionheart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I show the arrow for dropdown menu in excel? | Excel Worksheet Functions | |||
Data validation dropdown arrow disappeared | Excel Discussion (Misc queries) | |||
In-Cell Dropdown for validation not displaying | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |