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 |
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