Appending or Up-dating a formula

  • Thread starter Thread starter john
  • Start date Start date
J

john

I am using an =Ave function in a formula to average quite a few cell values
together. I add new information all the time; sometimes 5 or 6 new cells at
a time.

How can I append or up-date my formula to include these new cells with out
have to type the new cells into the formula?

When I make the cell that has the formula in it active/edit, all of the
cells that are referenced in the formula have a highlight around them.

Is there a key or key combination I can press while clicking on the cells I
want to add to the formula?



Thanks,

john
 
Back
Top