Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
Autofill in a basic Excel document seems to be selective when moving from
cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
If you actually mean "Autocomplete" and not "Autofill" then be aware that the
data must be contiguous in the same column above or below the cell you expect the autocomplete to work. Gord Dibben MS Excel MVP On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote: Autofill in a basic Excel document seems to be selective when moving from cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
Yes, I do mean "Autocomplete". The issue does involve the same column. I
have even made sure that the caps were consistent, but it hasn't made any difference. For example: It will enter "Sean" after entering an "S", but when a "D" is entered nothing happens even though"Deboroh" is in the same column many times. "Gord Dibben" wrote: If you actually mean "Autocomplete" and not "Autofill" then be aware that the data must be contiguous in the same column above or below the cell you expect the autocomplete to work. Gord Dibben MS Excel MVP On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote: Autofill in a basic Excel document seems to be selective when moving from cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
Do you have any other names (words) in that column that start with "de"...
if so, auto-complete will not know which name you want, so I believe it waits until only one possibility remains before showing it to you. Rick "DSV" wrote in message ... Yes, I do mean "Autocomplete". The issue does involve the same column. I have even made sure that the caps were consistent, but it hasn't made any difference. For example: It will enter "Sean" after entering an "S", but when a "D" is entered nothing happens even though"Deboroh" is in the same column many times. "Gord Dibben" wrote: If you actually mean "Autocomplete" and not "Autofill" then be aware that the data must be contiguous in the same column above or below the cell you expect the autocomplete to work. Gord Dibben MS Excel MVP On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote: Autofill in a basic Excel document seems to be selective when moving from cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
Autocomplete works in the background, using spare CPU cycles. If you have a
lot of data for Excel to search through, it's possible that it won't find what you want as fast as you'd like, or it will give up before finding a match. Regards, Fred "DSV" wrote in message ... Yes, I do mean "Autocomplete". The issue does involve the same column. I have even made sure that the caps were consistent, but it hasn't made any difference. For example: It will enter "Sean" after entering an "S", but when a "D" is entered nothing happens even though"Deboroh" is in the same column many times. "Gord Dibben" wrote: If you actually mean "Autocomplete" and not "Autofill" then be aware that the data must be contiguous in the same column above or below the cell you expect the autocomplete to work. Gord Dibben MS Excel MVP On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote: Autofill in a basic Excel document seems to be selective when moving from cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill not consistent in document
This seems to have been the problem. The document did have a lot of data,
so I removed some of the older data to a separate worksheet and it it's fine now. You are a life saver! I will remember to keep to documents smaller from now on. Thanks. DSV "Fred Smith" wrote: Autocomplete works in the background, using spare CPU cycles. If you have a lot of data for Excel to search through, it's possible that it won't find what you want as fast as you'd like, or it will give up before finding a match. Regards, Fred "DSV" wrote in message ... Yes, I do mean "Autocomplete". The issue does involve the same column. I have even made sure that the caps were consistent, but it hasn't made any difference. For example: It will enter "Sean" after entering an "S", but when a "D" is entered nothing happens even though"Deboroh" is in the same column many times. "Gord Dibben" wrote: If you actually mean "Autocomplete" and not "Autofill" then be aware that the data must be contiguous in the same column above or below the cell you expect the autocomplete to work. Gord Dibben MS Excel MVP On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote: Autofill in a basic Excel document seems to be selective when moving from cell to cell. In one cell it works fine and in another it doesn't recognize an entry found many other times in the document. I've checked the "enable autofill" box. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Links Consistent Between Workbooks | Excel Discussion (Misc queries) | |||
Sub-Totals not consistent | Excel Discussion (Misc queries) | |||
Keep consistent between two worksheets | Excel Discussion (Misc queries) | |||
Consistent Formatting in Each Worksheet | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |