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

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