Hello,

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper

=D$8

Use the '$' to keep rows or columns from changing when you select multiple
of them.

" wrote:

Hello,

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper

wrote:
Hello,

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper

TDOG wrote:
wrote:
Hello,
Type in cell B1 as follows =$d$8 and then copy to b2 to b25

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper

Hello rcc,

Thank you for your quick response and help! The function works great!

Thank you,
Jamres Cooper


rcc wrote:
=D$8

Use the '$' to keep rows or columns from changing when you select multiple
of them.

" wrote:

Hello,

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper

Hello TDOG,

Thank you for your quick response and help! The function works great!

Thank you,
James Cooper


TDOG wrote:
TDOG wrote:
wrote:
Hello,
Type in cell B1 as follows =$d$8 and then copy to b2 to b25

How do you copy and paste a function from one cell to another cell in
the same workbook?

This is what I'm tring to do if cell D8 has a date 7/12/2006 then in B1
- B25 I would like to paste the function =D8.

When I type the function =D8 in cell B1 then I select B2 - B25 and
Paste or Paste Special it changes the Function to in cell B2 =D9, B3
=D10, B4 =D11 it increments by one in the next cell.

How can I copy and paste a function from D8 to B1 - B25 without the
function incrementing in each cell?

Thank you for your help,
James Cooper