Appending or Up-dating a formula

Giganews Newsgroups
Subject: Appending or Up-dating a formula
Posted by:  john (
Date: Thu, 27 May 2004

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?