Applying formula to an entire column
 

I would like to be able to do this on, lets say, an unused spreadsheet that
only has the labeling completed (track sales etc). I would like certain
columns to have a formula in place that will automatically perform the
desired function. As of right now, I have thr formulas in place but I have to
"drag" the formula down to the new entry so that the formula then applies to
that data.
So question is: How do I set the formula to automatically apply to all new
data entries in that given column without having to manually apply the
formula?
Thanks
Stephan

Applying formula to an entire column
 

Stephan,

In Tools - Options, Edit tab, select "Extend list formats and formulas." It
will then automatically copy down formulas in tables as you add rows, with
certain restrictions.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Stephan" wrote in message
...
I would like to be able to do this on, lets say, an unused spreadsheet that
only has the labeling completed (track sales etc). I would like certain
columns to have a formula in place that will automatically perform the
desired function. As of right now, I have thr formulas in place but I have
to
"drag" the formula down to the new entry so that the formula then applies
to
that data.
So question is: How do I set the formula to automatically apply to all new
data entries in that given column without having to manually apply the
formula?
Thanks
Stephan