Copy Past Efficiency (Shortcut)

**kimberlyre2000** · 11-26-2012, 01:20 PM

Row 1 (Columns A through DL) has numerous formulas I want to copy down to Row 33835.

Most efficient want to do this (without dragging) - is there a way to use "Go To" or somethiing similar.

I have multiple workbooks I am doing this on and each has a different number of rows I am copying to.

Thank you.

**Ron Coderre** · 11-26-2012, 01:40 PM

Try this:
• Select A1:DL1
• CTRL+C...to copy that range
• F5...to open the Go To dialog
...Reference: A33835
...Hold down SHIFT and press ENTER
(That will select from A1:A33835)
• Press ENTER to paste the source range.

Is that something you can work with?