How do I write a formula to many cells at a time in Excell?

R

Ragdyer

In the future, please enter your question(s) in the *body* of the post.

Select the range of cells that you wish to enter the formula into.
The cell in focus (colored white) is the cell that you should direct the
references to.

After the formula entry is complete, simply do:
<Ctrl> <Enter>.
 
B

Bernard Liengme

Please be more specific:
1) cell in a range (a rectangle of cells)
2) cells that are non-contiguous (not all next to each other)
3) cells on different worksheets
Tell us more
best wishes
 
Top