Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pointing on a cell shows me a list . . .how to do that ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pointing on a cell shows me a list . . .how to do that ?
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. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Jo?l" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
change size of in cell drop down list | Excel Discussion (Misc queries) | |||
How to create a List inside a cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions |