| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| make cell length always equal 10 | Excel Discussion (Misc queries) | |||
| can I make worksheet name equal a cell | Excel Worksheet Functions | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| How do I make one cell equal to another | Excel Worksheet Functions | |||
Linear Mode
