How do I make a range of cells equal to one cell
 

How do I make a range of cells equal to one cell outside the range. ie.all
the cells A10:A20 equal to D3

How do I make a range of cells equal to one cell
 

Select A10:A20 (all 11 cells)
type this:
=$d$3
and hit ctrl-enter to fill all the selected cells with that formula.

If D3 can be empty, you may want to use:
=if($d$3="","",$d$3)

jggsfl wrote:

How do I make a range of cells equal to one cell outside the range. ie.all
the cells A10:A20 equal to D3

--

Dave Peterson

How do I make a range of cells equal to one cell
 

Thank you, worked great.

"Dave Peterson" wrote:

Select A10:A20 (all 11 cells)
type this:
=$d$3
and hit ctrl-enter to fill all the selected cells with that formula.

If D3 can be empty, you may want to use:
=if($d$3="","",$d$3)

jggsfl wrote:

How do I make a range of cells equal to one cell outside the range. ie.all
the cells A10:A20 equal to D3

--

Dave Peterson