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

See how to copy formula through a huge range using keyboard shortcuts:
1) Make formula in cell A6
2) Hightlight cell A6
3) copy cell A6
4) Hight F5 key (Go To)
5) Type destination cell (like A366)
6) Hold Shift
7) Hit Enter
8) Ctrl + V to paste

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• VLOOKUP
• MATCH
• DATEDIF
• SUMIF
• SUMPRODUCT
• INT
• functions
• formula
• array
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• HR
• Salary
• Calculation
• Based
• On
• Relevant
• Years
• Worked

[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!

[Markblackburn86]

Wow, so simple and so helpful. Thank you

[ExcelIsFun]

I am glad that you like it!

[ExcelIsFun]

I am glad that you like it!

[fressy98]

Great! Practical trick! Thanks!