5 ms·
It lives on as autofill in google sheets: if you write down a set of related terms in a spreadsheet, you can drag from the corner to extend the range using thos
by dan-robertson 6y ago
It lives on as autofill in google sheets: if you write down a set of related terms in a spreadsheet, you can drag from the corner to extend the range using those sets, just like you can extend an arithmetic progression or formula
- barbecue_sauce 6y agoDidn't that feature originate in Excel?
- DanBC 6y agoI think "AutoFill" first appeared in Excel 4 (1992), and was extended in Excel 5. https://books.google.co.uk/books?id=imoPAQAAMAAJ&q=excel+4.0+autofill&dq=excel+4.0+autofill&redir_esc=y&hl=en https://books.google.co.uk/books?id=imoPAQAAMAAJ&q=excel+4.0... I've found searching the web for things like "when was the fill handle introduced" or "who invented the fill handle" or "what's the history of the fill handle" gives hopeless results.
- quietbritishjim 6y agoThe parent comment is specifically about Google Sets-style autocomplete of a text list, not just autocomplete in general.
- barbecue_sauce 6y agoI'm still not sure I get the distinction.
- ml_basics 6y agoWhen I try this, it just repeats the items in order, e.g. "New York, London, Tokyo" autofills to "New York, London, Tokyo, New York, London, Tokyo,..." Do you need to do something special to activate intelligent autofill, e.g. adding "Paris" in my example?
- WrtCdEvrydy 6y agoI think it needs 3-4 items to get intelligent autofill?
- dmos62 6y agoThese instructions don't seem to work.
- crazygringo 6y agoAlas, that appears to have died way back in 2014 [1]. I remember the first time I used that, however -- it seemed like absolute magic. [1] http://www.evolvingseo.com/2014/05/20/google-sets-retired-from-new-google-sheets/ http://www.evolvingseo.com/2014/05/20/google-sets-retired-fr...
- dan-robertson 6y agoIt seems my memory is not useful when it relates to google products.