Quote Originally Posted by tim201110 View Post
skip a row in sheet 1 and 2 and begin to input any string from A1:A3
Hi tim,
Ahh, silly me, I had forgotten what autofill was !! Or rather I was assuming that Excel Autofill was referring to being able to “drag down” a value, ( fill by using the fill handle http://www.excelfunctions.net/Excel-Autofill.html __ or various copy and paste techniques http://www.eileenslounge.com/viewtop...=24852#p192980 http://www.eileenslounge.com/viewtop...=24852#p192987 http://www.eileenslounge.com/viewtopic.php?f=27&t=25068 )


I think we are referring here to Automatically repeat values that already exist in a column

The normal characteristics is that if I begin typing any word immediately below a row of already fully filled in ( no empty rows ) section, then Excel helps me and suggests one of the above words such as this: _...
autofill.JPG http://imgur.com/MNOQYRL
_..- for that screenshot, I had just typed _ d _ into cell A4, but Excel offered me a full word.

If I had attempted that in cell A5 , Excel would have not tried to help me with a suggestion.

The above is the auto fill that I know.
It appears only to work for rows immediately above until no spaces are encountered. ( Actually it will work for all “connected” rows** ).

For example here in cell A5_....
Using Excel 2007 32 bit
Row\Col
A
B
1
 abc
2
 y
3
 dfe
4
 ghi
5
 y
6
 y
Worksheet: 1 (2)
¬_..... I would get offered _ dfe _ if I typed _ d _ into cell A5 _ . Similarly , if I typed _ g _ into cell A5 , Excel would offer me _ ghi _ ( in cell A6 Excel would not help me )
In cell A2 if I began typing the first letter of any of those character strings, then Excel will offer me the full character string beginning with that letter. ( So in fact this Automatically repeating of values that already exist in a column works for all connected rows**. )

In your Sheet2 , the limitations caused by empty rows have been removed

I cannot see how you have achieved this. ??? I can achieve this by filling all cells in the column with any character and giving them a colour of white , should I not wish to see them.

If I could do this whilst leaving the cells blank, that could be quite useful.

Care to explain how you have done it ?

Alan