Autofill new row in lists
 

I am very new to excel (2003). I download and adapted a yearly (monthly
columns) budget template,
http://office.microsoft.com/en-us/te...CT101172321033
Wanting to add a graph that will automatically add new entries I have used
'lists'. The problem is (I hope this isn't a stupid question), when I add a
new row (item) to the list where the * is, the formatting is copied down, but
the 0.00 in above cells are not copied (with the exception of the 'total'
formula in the last column). So the 'sum' formula, in the last column is
constaintly telling me that "the formula refers to empty cells", which is
rather annoying. Is there anyway that the zero value in the cells above can
automatically appear if I add a new row (item) in the same way that the
formatting does?

Thanks in advance

Autofill new row in lists
 

The "Extend data range formats and formulas" does not apply to manually entered
data as the zeros are in that Template.

You can enter the zeros in the inserted rows or turn off the error-checking so
you won't be annoyed.

I turned mine off long time past.


Gord Dibben MS Excel MVP


On Thu, 25 Oct 2007 17:14:01 -0700, Zetta
wrote:

I am very new to excel (2003). I download and adapted a yearly (monthly
columns) budget template,
http://office.microsoft.com/en-us/te...CT101172321033
Wanting to add a graph that will automatically add new entries I have used
'lists'. The problem is (I hope this isn't a stupid question), when I add a
new row (item) to the list where the * is, the formatting is copied down, but
the 0.00 in above cells are not copied (with the exception of the 'total'
formula in the last column). So the 'sum' formula, in the last column is
constaintly telling me that "the formula refers to empty cells", which is
rather annoying. Is there anyway that the zero value in the cells above can
automatically appear if I add a new row (item) in the same way that the
formatting does?

Thanks in advance

Autofill new row in lists
 

Thanks Gord, I will do that.
--
Cheers Zetta


"Gord Dibben" wrote:

The "Extend data range formats and formulas" does not apply to manually entered
data as the zeros are in that Template.

You can enter the zeros in the inserted rows or turn off the error-checking so
you won't be annoyed.

I turned mine off long time past.


Gord Dibben MS Excel MVP


On Thu, 25 Oct 2007 17:14:01 -0700, Zetta
wrote:

I am very new to excel (2003). I download and adapted a yearly (monthly
columns) budget template,
http://office.microsoft.com/en-us/te...CT101172321033
Wanting to add a graph that will automatically add new entries I have used
'lists'. The problem is (I hope this isn't a stupid question), when I add a
new row (item) to the list where the * is, the formatting is copied down, but
the 0.00 in above cells are not copied (with the exception of the 'total'
formula in the last column). So the 'sum' formula, in the last column is
constaintly telling me that "the formula refers to empty cells", which is
rather annoying. Is there anyway that the zero value in the cells above can
automatically appear if I add a new row (item) in the same way that the
formatting does?

Thanks in advance