4
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.
user715002
Posted 2017-04-06T18:46:26.370
Reputation: 43
In windows, I double click the box in the bottom right of the cell to auto fill, may work on mac too. – mt025 – 2017-04-06T18:51:12.850
Hey bingo! It works. Thanks! Put it as an answer and I'll upvote it. – user715002 – 2017-04-06T18:52:53.913
According to Mac Excel Control Shift RIght Arrow, you might be able to use Fn+Shift+Alt+down arrow to select the appropriate cells, in case that is any use (saves scrolling to the last cell).
– Andrew Morton – 2017-04-06T18:55:22.0901I don't believe this is a duplicate, because it specifically asks about key shortcuts on a Mac, whereas the other post details key shortcuts in Windows. – Adam – 2017-04-06T20:51:54.053