Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell text completion
Hi,
I am making an index of worksheets tat I use for my pupils. When I type in some cells excel offers me some text that is in previous cells in the column. Some other columns don't offer me this option. Is it possible to make all columns offer me this option? Thanks |
#2
|
|||
|
|||
Autocomplete or "Pick from list" gets its information from cells above and
below the point in the same column that you are entering new data. If this data is disturbed by blank cells above or below, the Autocomplete can/will fail. Gord Dibben Excel MVP On Sat, 8 Oct 2005 20:40:32 +0100, nospam wrote: Hi, I am making an index of worksheets tat I use for my pupils. When I type in some cells excel offers me some text that is in previous cells in the column. Some other columns don't offer me this option. Is it possible to make all columns offer me this option? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
How do I print all the text in a cell | Excel Discussion (Misc queries) |