Forum Discussion
Auto suggesting text in column
On a worksheet I have typed a word in a cell, when I type the same word in the cell directly below, Excel autosuggests the same word for you. When typing this word 10 empty cells lower, there is no suggestion and I have to type the same word completely.
I tried to see if Options could help me, but nothing found there.
Who can help to turn the autosuggestion on?
More accurately, AutoComplete works within a contiguous range where at least one cell in each row is filled:
6 Replies
As you have found, autocomplete stops working as soon as there is an empty cell above the active cell.
As far as I know, you'd have to enter something in the empty cells, even if only a space.
Hi Hans,
Thank you for your reply.
In another Excel sheet, I am keeping a record of the milage I drive for my work.
I visit ships and when I enter the ship's name for the second time, no matter how far up the first entry is, it puts the complete name down and it has plenty really empty cells (no formula, conditional format or text) and cells with different names between these two entries.
I have tested it with a name in row 5 and when I type that same name in row 135 after two letters input, it autocompletes it without a problem.
The further down I go, the more letters I need to get the autocomplete to fill in the rest.
after 225 lines, I need 4 letters, after 300 lines, it needs 5 letters.
Now I am using an Excel sheet (not set-up by myself) and it does not work anymore.
The cell right below, one letter activates the autocomplete. Two cells below and it does not work anymore. Also when I open a new workbook, it is as you explained: leave one empty cell and it stops.
Where is that setting (if it exists) that turns auto complete on or off?
To help me in this case, I have shortened the name I have to repeat to one letter and when ready, replace it in the selected column with CRTL+F routine to the proper name.
More accurately, AutoComplete works within a contiguous range where at least one cell in each row is filled:
