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.