| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excell lists choosing quickly from the list
I am endeavouring to choose quickly from a list defined in a cell created in
excell. i.e if the list is: Excellent Good Fair Poor ICan you get the cell to autoselect good if you start typing G? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
in excell lists choosing quickly from the list
Hi,
You could type all four words in say A1,A2,A3 and A4. Then highlight the rows right click and hide them, when you start typing in A5 it should do what you want. -- Regards Warren If this helps please click the Yes button. "shubb1" wrote: I am endeavouring to choose quickly from a list defined in a cell created in excell. i.e if the list is: Excellent Good Fair Poor ICan you get the cell to autoselect good if you start typing G? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHOOSING FROM OFFERED LIST OF FUNCTIONS-XL2007 | Excel Discussion (Misc queries) | |||
| Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
| How do I populate an entire row by choosing one cell from a list | Excel Discussion (Misc queries) | |||
| choosing off various lists | Excel Worksheet Functions | |||
| How to create lists of data quickly from a pre-existing database | Excel Discussion (Misc queries) | |||
Linear Mode
