Pointing on a cell shows me a list . . .how to do that ?

G

Guest

Hi all,
I found an interesting option but cannot reproduce it !
From a single cell, I may select an element from a list apart
It is not a box so not a shape but simply a common cell . . . when pointing
on that cell, a small triangle appears on the right edge and permits to see
the whole list, select an element which appears then in the cell itself
Any idea how to generate it again ?
Thanks for your help
Joël
 
A

Arvi Laanemets

Hi

Data > Validation, and select List from drop-down choices. You can enter the
list directly (using delimiters defined in Windows international settings),
you can refer to list of values on same sheet, or you can refer to some
named range, which defines the list of values on any sheet of workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use a single nonrepeating XML element in a cell formula 1
Copy one cell to another using a filter 1
Limiting selection in a cell AND linking that selection to a list 1
How do I show that a drop down list exists in a cell? 1
How to create a List inside a cell? 6
How do I format part of a text cell, but not the whole thing? 2
how do I insert a single quote on every cell in a column to make . 2
How do I get a list to display colours 8

Top