| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I enable auto complete?
I have the auto complete option checked, however, if there are blank cells
above the cell I want to auto complete, it will not recognize any entries above. Can excel autocomplete from more than the choices directly above it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I enable auto complete?
You might be able to use Excel's Autocorrect. Choose Tools, Autocorrect
e.g. Replace vh, Replace With:= Val Hearon would this be suitable? Peter "ValHearon" wrote: I have the auto complete option checked, however, if there are blank cells above the cell I want to auto complete, it will not recognize any entries above. Can excel autocomplete from more than the choices directly above it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I enable auto complete?
Excel will also autocomplete from contiguous cells below the insertion point.
Note the word "contiguous"..................above or below. Gord Dibben MS Excel MVP On Fri, 28 Mar 2008 07:44:00 -0700, ValHearon wrote: I have the auto complete option checked, however, if there are blank cells above the cell I want to auto complete, it will not recognize any entries above. Can excel autocomplete from more than the choices directly above it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto complete only for one row down? | Excel Discussion (Misc queries) | |||
| Auto Filter With Auto Complete Ability | Excel Discussion (Misc queries) | |||
| Auto complete | Excel Worksheet Functions | |||
| Auto complete | Excel Discussion (Misc queries) | |||
| Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
