Does anybody know the keyboard shortcuts or menu commands to fill a formula down *without* dragging? I'm using Excel for Mac 2011 on a MacBook.

I've got a spreadsheet like this pattern but for like 5000 rows:

```
A, B, C, D
5, 1, 3 =SUM(A1:C1)
3, 2, 4
...
```

I know how to hover over D1 and get the handle and drag down, but there must be an easier way.

There are a billion tips online but I'm not finding any that work.

FWIW, Macbook has some exceptions to shortcut key rules, so that's probably why, I guess.

But anyhow, anyone know how to do this?

PS: I would have thought "fill series" would be a choice but no. Here's a picture.