7

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.

A picture

slhck
  • 235,242
user715002
  • 73

1 Answers1

9

Double click the box on the bottom right of the cell with the formula, as shown in your screenshot. It will fill the formula until it finds a blank row.

mt025
  • 3,506