Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Drop down list question

I have created a drop down list on sheet 1 from named lists on sheet 2, does
anyone know how to make the drop down arrows stay visible as opposed to only
showing when the cell is clicked on?

Your help is greatly appreciated.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Drop down list question

Not possible using DV list dropdowns.

Color the cell with the dropdown.

Draw a little triangle in the corners of the cell.

Use a ComboBox instead of DV dropdown.


Gord Dibben MS Excel MVP

On Thu, 31 Jul 2008 13:13:02 -0700, Xhawk57
wrote:

I have created a drop down list on sheet 1 from named lists on sheet 2, does
anyone know how to make the drop down arrows stay visible as opposed to only
showing when the cell is clicked on?

Your help is greatly appreciated.


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
Drop down list question Justin Excel Discussion (Misc queries) 0 May 8th 08 12:46 PM
Drop Down List Question Dallas PM Excel Discussion (Misc queries) 3 April 22nd 08 12:30 PM
Drop Down List Question metaltecks Excel Discussion (Misc queries) 1 October 2nd 06 03:33 PM
Drop Down List Question EyeNoNothing Excel Discussion (Misc queries) 3 February 7th 06 10:19 AM
Drop down list question LilaDuncan New Users to Excel 7 February 4th 05 04:14 PM


All times are GMT +1. The time now is 02:19 AM.

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

About Us

"It's about Microsoft Excel"