Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
REPEATING TEXT ENTRIES TO COME UP WHEN TYPING FIRST LETTER
I WANT RECURRING ENTRIES INTO EXCEL TO POP UP AS I TYPE THE FIRST LETTERS.
SOMETIMES IT IS HAPPENING BUT MOST OF THE TIME IT IS NOT. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
REPEATING TEXT ENTRIES TO COME UP WHEN TYPING FIRST LETTER
Please do not post in all upper case letters - it makes you post harder to
read and it is considered to be shouting. For autocomplete to work there must be a continuous connected path of cells with data in between the new entry and the previous entry of that same data. E.G. If you have data in B1:B10 and you start to enter the same data as B1 in B12, autocomplete will not work because the entry cell in isolated from the data. If however there was a continuous set of data in column A - say a series of dates down to A12 - then autocomplete will work because it is *connected* to the original data. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "STEVEAL" wrote in message ... I WANT RECURRING ENTRIES INTO EXCEL TO POP UP AS I TYPE THE FIRST LETTERS. SOMETIMES IT IS HAPPENING BUT MOST OF THE TIME IT IS NOT. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set a drop-down to auto-pop. by typing first letter? | Setting up and Configuration of Excel | |||
Can you toggle between different text colors while typing text | Excel Discussion (Misc queries) | |||
how do i go to a cell by just typing a letter | Excel Discussion (Misc queries) | |||
Copying different repeating entries down a column | Excel Discussion (Misc queries) | |||
can i select from list by typing first letter of word? | Excel Discussion (Misc queries) |