ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   displaying borders when editing the formulas (https://www.excelbanter.com/setting-up-configuration-excel/21518-displaying-borders-when-editing-formulas.html)

ALK

displaying borders when editing the formulas
 
When I doubleclick on the formula to see its components, the usual "borders"
around the precedents do not appear.

The formula bar on top still shows the formula, but without familar borders
it is so much more time consuming to edit the cell.

Any ideas why it happens and how I can correct it?

Thanks!!

Kassie

Try the following:
Click on Tools|Options, and then, on the View Tab, Under Window options,
tick the Formulas option

"ALK" wrote:

When I doubleclick on the formula to see its components, the usual "borders"
around the precedents do not appear.

The formula bar on top still shows the formula, but without familar borders
it is so much more time consuming to edit the cell.

Any ideas why it happens and how I can correct it?

Thanks!!


ALK

Thanks Kassie, but that's not exactly what I was looking for.

I can see the syntax of the formula, regardles.

I also tried resetting the Options settings to make them the same as in
other worksheets, where the borders are displayed, but I can't be the case,
becase only ONE tab in the file isn't displaying formulas the way I want.

"ALK" wrote:

When I doubleclick on the formula to see its components, the usual "borders"
around the precedents do not appear.

The formula bar on top still shows the formula, but without familar borders
it is so much more time consuming to edit the cell.

Any ideas why it happens and how I can correct it?

Thanks!!



All times are GMT +1. The time now is 08:35 PM.

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