ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 - cells in formula? (https://www.excelbanter.com/excel-discussion-misc-queries/2467-excel-2003-cells-formula.html)

Tom Walker

Excel 2003 - cells in formula?
 
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!
==============================================

"Tom Walker" wrote in message
...
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



All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com