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