Need help

Copper Contributor

I am new to Excel and I use Mac .I need to know the shortcut key for Mac on how to autofill data in the quickest way possible . For example, in the pic, in column I, (freeze) I need to autofill the formula throughout my entire row.there is around 1500 rows on the data.I could simply click the green icon to drag my formula vertically but its gonna take a long time . So what is the best approach?Screen Shot 2022-03-27 at 12.37.51.png.

1 Reply

@Sakchu Just double-click on that green icon. Same on Excel for PC, by the way.