Autocomplete

R

Renee

When using Autocomplete to fill cells, I have two
different responses. In one computer workbook, I can only
use Autocomplete in a continuous cell progression in a
specific column. Each row has to have type in them to pull
from.

In a different workbook in another computer in my office,
I can type in the same column but with rows that remain
empty and it still uses Autocomplete to pull text from.

Example: Column D - If text is in rows 1-10, then I skip
11, I can't use the information from rows 1-10 in cell
12.

However, in the other computer workbook, I can have
information in Column D intermittently (rows 1, 4, 7, 10,
17, 20, etc.) then go to row 12 and type text and it will
use Autocomplete and fill in information from somewhere
else in that column.

Why?
 
J

JE McGimpsey

Autocomplete works for entries within or adjacent to the data region
(the area by empty rows and columns. If the data region includes A1:J10,
an entry in A11 will autocomplete, even if A9:A10 are empty.
 
R

Renee

It doesn't work in my computer. I went in several
workbook pages and typed data into the first ten cells,
then skipped the eleventh and tried to input information
from any of the first ten and it didn't Autocomplete the
information. Any reason why and/or how do I change this?
 
J

JE McGimpsey

What you wrote is exactly the behavior I described.

If you had, say B1:B11 filled as well as A1:A10, then tried to input in
A12, Autocomplete will work.

IF row 11 is completely blank, however, the dataregion stops at row 10
and your entry in row 12 won't autocomplete.
 
Top