Forum Discussion
Excel Mac 2019 Autofill, how to bild a list (on windows it works, on Mac it doen´t)
I try to bild a list like:
1. Beer
2. Beer
3. Beer
....
99. Beer
On Mac Office 2019 i would write "1. Beer", than enter, in the 2nd line than "2. Beer", than mark both of them and than I would click to the small dot in the right corner and pull the autofill handle down.
What I get on Mac is:
1. Beer
2. Beer
1. Beer
2. Beer...
on Win I get the correct list which is...
1. Beer
2. Beer
3. Beer
hm... is this a bug or a feature in Excel Mac? how can I generate this list on Mac easily?
Thx...
1 Reply
hongtongtong Not a bug. Excel for Mac simply doesn't have all the features.
You could first build your number sequences and then use a simple formula like
=A1&". Beer"in the next and copy it all the way down. Copy/paste values on top of itself and delete the first column.
Or use Flashfill.
