View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default How do I write a formula to many cells at a time in Excell?

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.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"fgurdal" wrote in message
...