Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I show the arrow for dropdown menu in excel?

If you don't "click" on the cell, you would not know it has a dropdown list.
I want this to be visible without clicking on the cell. Also, my dropdown
list when clicking on it, shows on the outside (right side) which is outside
the cell. I noticed that Microsoft, in their dropdown list, it shows and is
inside the cell.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how do I show the arrow for dropdown menu in excel?

You can't, for Data validation (DV) dropdowns. But you could easily
format/color the cell to make it distinctive. Or insert a comment on the DV
cell (and show the comment).

One alternative - you could try using a combo box from the Forms toolbar,
and draw it sized to fit to grid -- hold down Alt key when you draw/resize --
so that it looks like it's inside the cell. The dropdown will be visible. It
does take more work to get it up though, compared to DVs.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dorinc29" wrote:
If you don't "click" on the cell, you would not know it has a dropdown list.
I want this to be visible without clicking on the cell. Also, my dropdown
list when clicking on it, shows on the outside (right side) which is outside
the cell. I noticed that Microsoft, in their dropdown list, it shows and is
inside the cell.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't click on dropdown menu in excel, but others can. Help! ivan Excel Discussion (Misc queries) 1 April 10th 08 06:57 PM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
In Excel how do I set up the list from the Data dropdown menu? Gypsy Taylor Excel Discussion (Misc queries) 4 October 18th 06 04:01 AM
Create Dropdown menu without using the Validation on the Data Menu lostinformulas Excel Worksheet Functions 0 July 13th 06 08:47 PM
Show last files used in File dropdown menu Ladywulfe New Users to Excel 1 August 6th 05 07:53 AM


All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"