SOLVED

Flash Fill and Dragging Down Formulas Alternatives

%3CLINGO-SUB%20id%3D%22lingo-sub-2981831%22%20slang%3D%22en-US%22%3EFlash%20Fill%20and%20Dragging%20Down%20Formulas%20Alternatives%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981831%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20Flash%20Fill%20a%20formula%20or%20Drag%20Down%20a%20formula...%20let's%20say%205000%20rows%2C%20without%20using%20VBA%20or%20dragging%20the%20box%20down%205000%20rows%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20formula%20is%20in%20Cell%20F2%3AF4%20and%20is%3DTODAY()-E2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2981831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981967%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20and%20Dragging%20Down%20Formulas%20Alternatives%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758822%22%20target%3D%22_blank%22%3E%40JLaz86%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20F5%20to%20activate%20the%20Go%20To%20dialog.%3C%2FP%3E%0A%3CP%3EEnter%20F2%3AF5000%20in%20the%20Reference%20box%2C%20then%20click%20OK%20or%20press%20Enter.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BD%20to%20fill%20the%20formula%20down.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20E2%3AE5000%20have%20been%20filled%2C%20you%20can%20also%20double-click%20the%20fill%20handle%20in%20the%20lower%20right%20corner%20of%20F2%20(if%20F3%20and%20below%20are%20empty)%20or%20F4%20(since%20F3%20and%20F4%20already%20have%20a%20formula%20in%20your%20sample%20workbook)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

 

Thanks,

 

2 Replies
best response confirmed by JLaz86 (New 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.