Excel Magic Trick 630: Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range

[Markblackburn86]

Wow, so simple and so helpful. Thank you

[Mishkafofer]

Excellent Tip, i am working on humongous excel spreadsheet with 20,572 rows (preparation of data for statistical analysis in econometric software) and need quick step such as this to change data.

My small tip for other for doing the same: after creating cells with formulas, do a special paste to other column and copy only values, statistical software don't like excel formulas, only simple data.

[ExcelIsFun]

EXCELlent tip! Thanks!

[Valkyries101]

i wish i watched this video before dragging formula in workbook has 5000 rows,Thanks

[ExcelIsFun]

Yes, but next time you will know this!!!!

[udanial]

sir from where u bring these tricks its awesome!

[ExcelIsFun]

I guess the tricks come from the Excel-Is-Fun-Zone!

[fressy98]

Great! Practical trick! Thanks!

[ExcelIsFun]

I am glad that you like it!

[fressy98]

Great! Practical trick! Thanks!

[ExcelIsFun]

I am glad that you like it!