ExcelBanter - copy a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy a range (https://www.excelbanter.com/excel-worksheet-functions/204849-copy-range.html)

Dave

copy a range

I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it

Sean Timmons

copy a range

aside from highlighting and pasting? Does it match the height of a table? Use
Ctrl+arrow keys to quickly navigate to top/bottom/left/right of table and
paste.

"Dave" wrote:

I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it

Per Jessen

copy a range

Hi

Copy the cell with your formula, then select the cells where you want the
formula to copied to, then goto Edit Paste special Check "Formulas"
OK¨

Regards,
Per

"Dave" skrev i meddelelsen
...
I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it

Gord Dibben

copy a range

Select the cell with the formula............say A1

In NameBox type A1:A1200 and ENTER

CTRL + d to copy down.

Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 11:55:03 -0700, Dave
wrote:

I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it

All times are GMT +1. The time now is 07:51 PM.