If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Text in formula bar is not displaying in cell | Mike | General Discussion | 0 | August 29th, 2005 09:47 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Help inserting a Cell Value in a Text Cell | Dave | Worksheet Functions | 5 | March 5th, 2005 09:06 PM |