Flash Fill and Dragging Down Formulas Alternatives

New Contributor

Is there a way to Flash Fill a formula or Drag Down a formula... let's say 5000 rows, without using VBA or dragging the box down 5000 rows?


My formula is in Cell F2:F4 and is=TODAY()-E2.




2 Replies
best response confirmed by JLaz86 (New Contributor)


Press F5 to activate the Go To dialog.

Enter F2:F5000 in the Reference box, then click OK or press Enter.

Press Ctrl+D to fill the formula down.


If E2:E5000 have been filled, you can also double-click the fill handle in the lower right corner of F2 (if F3 and below are empty) or F4 (since F3 and F4 already have a formula in your sample workbook)

Thanks, @Hans Vogelaar. This was a great option and worked perfectly. The shortcut F5 for Go To has been something I've never known I needed until now <3.