Roger,
What I meant was that if you enter a row above B11, and then enter a value
in the new B11, the old B11 (now B12 - this is getting confusing :))
automatically updates to reflect that row.
Odd thing is, it doesn't work with formulae directly, in the instance you
state, it updates by adding a value in A11. If the formula in B1 was =C1+D1
etc., it updates when the values are added to C11 AND D11.
Regards
Bob
"Richard Buttrey" wrote in
message ...
Hi Bob,
Yes, I have A1:A10 populated with some data and formatted say Red.
B1:B10 has formulae =A1 etc.
A11 has =Sum(A1:A10), copied into B11.
I understood your reply to indicate that introducing a new row at A11,
with the "Extend List Formats & Formulas" ticked, would copy the
formatting and formulae from the row above.
The red formatting certainly gets copied, but not the formula in B10.
Rgds
On Fri, 14 Oct 2005 15:47:55 +0100, "Bob Phillips"
wrote:
Hi Richard,
I am not sure exactly what you refer to. Could you clarify for me?
Bob
"Richard Buttrey" wrote in
message ...
On Fri, 14 Oct 2005 14:44:16 +0100, "Bob Phillips"
wrote:
If you goto ToolsOptionsEdit and check the Extend list formats and
formulas box, it should work automatically..
Thanks Bob, That's one I hadn't spotted although it's selected in my
Excel application.
One problem is that while it extends the formats of rows above, it
won't extend any formulae. Am I missing something?
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|