This question already has an answer here: • 7 answers 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. Word for mac 2018.

Here's a picture.

Keyboard Shortcuts for Font & Fill Colors. So I developed an add-in that allows you to create keyboard shortcuts to change the font & fill colors. This add-in also lets you create keyboard shortcuts to apply other cell formatting properties like number formatting, borders, font size, protection alignment, etc. Mar 9, 2013 - Here's how to execute Fill Down: Step 1: After navigating to the active cell from which you would like to copy data, hold down shift + down arrow to expand the selection range. The data from the cell above now should be copied into the cell you have selected.