#1   Report Post  
Posted to microsoft.public.excel.setup
Rick
 
Posts: n/a
Default Pick Lists Problem

In my spreadsheet I have a drop down created using the Data,Validation
commands...it works just fine...I press the little arrow and get the proper
selection...however if I select the cell and right click to get the context
menu, the "Pick from drop down list" command does not show the proper list of
values...it appears to show the 3 lines immediately below the active
cell...how can I either deactivate the "Pick from drop down list" in the
context menu or get it to show the same list of values as the little arrow
button does???



Rick
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default Pick Lists Problem

Rick

Data Validation drop-down lists and "Pick from list" are two seperate functions.

DV lists are user-entered either by typing them into the dialog box or using a
range of cells.

Pick from list only shows what data is already entered contiguously in that
column.

You cannot de-activate it as far as I know.

Do not use the "pick from list" function if you want to select from the DV list.


Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 18:52:02 -0800, "Rick"
wrote:

In my spreadsheet I have a drop down created using the Data,Validation
commands...it works just fine...I press the little arrow and get the proper
selection...however if I select the cell and right click to get the context
menu, the "Pick from drop down list" command does not show the proper list of
values...it appears to show the 3 lines immediately below the active
cell...how can I either deactivate the "Pick from drop down list" in the
context menu or get it to show the same list of values as the little arrow
button does???



Rick


  #3   Report Post  
Posted to microsoft.public.excel.setup
Rick
 
Posts: n/a
Default Pick Lists Problem

Gord,

Thanks for the quick reply...at least I now know that I was not doing
something wrong...
--
Rick


"Gord Dibben" wrote:

Rick

Data Validation drop-down lists and "Pick from list" are two seperate functions.

DV lists are user-entered either by typing them into the dialog box or using a
range of cells.

Pick from list only shows what data is already entered contiguously in that
column.

You cannot de-activate it as far as I know.

Do not use the "pick from list" function if you want to select from the DV list.


Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 18:52:02 -0800, "Rick"
wrote:

In my spreadsheet I have a drop down created using the Data,Validation
commands...it works just fine...I press the little arrow and get the proper
selection...however if I select the cell and right click to get the context
menu, the "Pick from drop down list" command does not show the proper list of
values...it appears to show the 3 lines immediately below the active
cell...how can I either deactivate the "Pick from drop down list" in the
context menu or get it to show the same list of values as the little arrow
button does???



Rick



  #4   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default Pick Lists Problem

Thanks for the feedback Rick.

Gord

On Fri, 13 Jan 2006 10:02:04 -0800, "Rick"
wrote:

Gord,

Thanks for the quick reply...at least I now know that I was not doing
something wrong...


Gord Dibben MS Excel MVP
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
Capitalize Text if 2 lists are equal elevdown New Users to Excel 5 December 15th 05 04:56 PM
Excel - need a function to compare lists JerryMatson Excel Worksheet Functions 1 November 24th 05 05:09 PM
Problem With Reference Update Egon Excel Worksheet Functions 17 July 16th 05 05:45 AM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 01:04 AM
Baffling formula problem Ken Schmidt Excel Discussion (Misc queries) 2 December 21st 04 08:52 AM


All times are GMT +1. The time now is 03:31 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"