Excel 2003 - cells in formula?

[Tom Walker]

When I click on the end of a formula in a cell, I usually get all the
associated cells highlighted with different coloured borders.

I have one workbook with several sheets where this no longer happens on
just one sheet.

Is there some option I need to turn on in the sheet to make the coloured
cell borders appear? Or might it be something to do with very recently
using automaic update to bring my Office 2003 up to date?

Any assistance much appreciated.

Tom Walker

 

[RagDyer]

You should always get *exactly* the same actions if you would click in the
formula bar.

As far as having the cell itself highlight the all the other referenced
cells, try:
<Tools> <Options> <Edit> tab,
And check "Edit Directly In Cell".

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I click on the end of a formula in a cell, I usually get all the
associated cells highlighted with different coloured borders.

I have one workbook with several sheets where this no longer happens on
just one sheet.

Is there some option I need to turn on in the sheet to make the coloured
cell borders appear? Or might it be something to do with very recently
using automaic update to bring my Office 2003 up to date?

Any assistance much appreciated.

Tom Walker