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

  • Thread starter Thread starter jggsfl
  • Start date Start date
J

jggsfl

How do I make a range of cells equal to one cell outside the range. ie.all
the cells A10:A20 equal to D3
 
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)
 
Thank you, worked great.

Dave Peterson said:
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
adding text according to col with equal date 2
If statement for a range of cells 3
VBA set thick borders around non empty cells in range 0
cell equal worksheet title 3
Add a range to antoher range 3
How to synchronize all cell values? 1
Counting Problem 2

Back
Top