Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Phil
 
Posts: n/a
Default How do I get a list button to be displayed?

I've Created a List but when the cell is not selected the button does not
appear therefore it's dificult to remeber where the list is....


  #2   Report Post  
Mike
 
Posts: n/a
Default

color code it?

"Phil" wrote:

I've Created a List but when the cell is not selected the button does not
appear therefore it's dificult to remeber where the list is....


  #3   Report Post  
Phil
 
Posts: n/a
Default

Yes tried that and of course I can then see where the list is but is there an
option where u can select that the buttons remain in view ( a bit like
filers...)

thanks

"Mike" wrote:

color code it?

"Phil" wrote:

I've Created a List but when the cell is not selected the button does not
appear therefore it's dificult to remeber where the list is....


  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

You used Data|Validation?

I'd just color the cell, but maybe you could add a shape from the drawing
toolbar to look like that dropdown.

Phil wrote:

Yes tried that and of course I can then see where the list is but is there an
option where u can select that the buttons remain in view ( a bit like
filers...)

thanks

"Mike" wrote:

color code it?

"Phil" wrote:

I've Created a List but when the cell is not selected the button does not
appear therefore it's dificult to remeber where the list is....



--

Dave Peterson
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
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Auto scroll down data validation list [email protected] Excel Discussion (Misc queries) 4 January 28th 05 06:44 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 07:11 PM.

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"