| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto suggest entries?
Is it possible by Excel 2003 to suggest possible entries when we start
filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
Take a look at the options available under Data Validation and see if that
does what you need. Heidi "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
You are correct.
ToolsOptionsEditEnable Autocomplete works only in the same column. To get AC in any cell you will have to use Data Validation using a combo-box. See Debra Dalgleish's site for method and instructions. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On 11 Jan 2007 05:14:58 -0800, "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
Many Thanks.
The basic need of the request was to avoid using mouse. I knew about the validation tool (but not combobox), but it requies the use of mouse to clkick the drop down list. Is there a way to avoid double clicking to activate combobox? Or at least give me a keyboard shortcut for double click. I tried F2, it doesn't work. Thanks for the help. Regards Manju Gord Dibben wrote: You are correct. ToolsOptionsEditEnable Autocomplete works only in the same column. To get AC in any cell you will have to use Data Validation using a combo-box. See Debra Dalgleish's site for method and instructions. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On 11 Jan 2007 05:14:58 -0800, "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
I'm not sure if you can work this into whatever solution you select, but
When you're on a dropdown list, combo box, or cell with autocomplete options If you hold down [Alt] and press the down arrow...you'll see the list. Then you can arrow down/up to the item you want and press [enter] Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
Excellent. That's EXACTLY what I needed. a keyboard shortcut.
I love my keyboard Many Thanks Ron Coderre wrote: I'm not sure if you can work this into whatever solution you select, but When you're on a dropdown list, combo box, or cell with autocomplete options If you hold down [Alt] and press the down arrow...you'll see the list. Then you can arrow down/up to the item you want and press [enter] Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto suggest entries?
Thanks for the feedback....I'm glad I could help.
*********** Regards, Ron XL2002, WinXP "Manju" wrote: Excellent. That's EXACTLY what I needed. a keyboard shortcut. I love my keyboard Many Thanks Ron Coderre wrote: I'm not sure if you can work this into whatever solution you select, but When you're on a dropdown list, combo box, or cell with autocomplete options If you hold down [Alt] and press the down arrow...you'll see the list. Then you can arrow down/up to the item you want and press [enter] Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Manju" wrote: Is it possible by Excel 2003 to suggest possible entries when we start filling a cell. I am ready to have a column of possible entries in the same sheet. What I would like is to have excel suggest entries based on first few letters we type. I have seen this working only if the data is in the SAME column. Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto tab- Auto fill | New Users to Excel | |||
| Macro for Auto Fill | Excel Discussion (Misc queries) | |||
| Running auto correct on startup? | Excel Discussion (Misc queries) | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
Linear Mode
