Forum Discussion
hongtongtong
Jan 27, 2021Copper Contributor
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 w...
Riny_van_Eekelen
Jan 27, 2021Platinum Contributor
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.