SOLVED

Flash Fill and Dragging Down Formulas Alternatives

Copper 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.

 

Thanks,

 

2 Replies
best response confirmed by JLaz86 (Copper Contributor)
Solution

@JLaz86 

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.
1 best response

Accepted Solutions
best response confirmed by JLaz86 (Copper Contributor)
Solution

@JLaz86 

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)

View solution in original post