Fill a formula down without dragging in Excel for Mac 2011
28,440
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.
Related videos on Youtube
03 : 36
Apply a Formula to an Entire Column in Excel
02 : 51
How to copy a formula down a column in Excel without dragging
02 : 13
Excel Tutorial Tip 1 - Copy Formula Down Column. Excel Training Courses Sydney
03 : 46
Excel - AutoFill Thousands of Rows at Once in Excel
02 : 15
How to solve "drag to fill not working" or enable fill handle and cell drag & drop in excel
02 : 06
Excel Magic Trick 630: Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range
01 : 47
Fill a formula down without dragging in Excel for Mac 2011
Author by
user715002
Updated on September 18, 2022Comments
-
user715002 almost 2 years
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.
-
SineadCoyle over 2 yearsIf anyone else is struggling with this filling the whole way down, the column has to be right next to a column with data so it knows how far down to fill. I was trying to fill a formula in a column with a few rows of empty cells between it and the filled data, and it wasn't working.
