If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
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!! |
#3
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Way to make Excel only run certain formulas on a worksheet? | jrusso | General Discussion | 0 | January 12th, 2005 04:23 PM |
problem with table interior borders | Mark Urish | Tables | 1 | October 7th, 2004 11:55 AM |
Displaying cell formulas in certain cells only | E Edgington | Worksheet Functions | 4 | April 23rd, 2004 07:17 AM |
Relative vs. Absolute Values in Formulas | Worksheet Functions | 0 | January 22nd, 2004 11:59 PM |