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
__________________________