Selection Lists

  • Thread starter Thread starter Duncan Watson
  • Start date Start date
D

Duncan Watson

Using Excel 97.

What is the easiest way to create a 'drop-down' selection
list? I have a spreadsheet passed to me that contains a
column where each cell is like a Combo Box, when you click
in a cell you get a drop-down arrow and 4 selections to
choose from.

However I cannot get to view the Properties (from the
Control Box Toolbar) of the cells with selection lists as
you only get the choice to view the Properties of the
Worksheet. So I assume this is not a normal Combo Box?
Could it be a Pick List?

Also, whilst I can add my own Combo Box in cell A1 for
example, I cannot set it up so that when I make a
selection, another cell, B1 which is set to '=A1', in
another column is able to 'read' my selection. I just get
#N/A.

I hope this makes sense to someone, and thanks for any
help in advance,

Regards

Duncan
 
Hi Duncan

as far as i know this works in Excel 97 -
one of the easiest ways to create drop down lists is to use data /
validation
click on the cell that you want to have the drop down list in it
choose data / validation from the menu
choose list from the settings options
type your values in to the source line separated by commas
click OK

you might also like to have a look at the notes on Debra Dalgleish's site on
data validation for more ideas
http://www.contextures.com/tiptech.html


Hope this helps
Cheers
JulieD
 
Back
Top