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
|
|||
|
|||
long formula obscures cell view
I have a workbook with very long formulas (basically external links to
several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions |
#2
|
|||
|
|||
You can hide the Formula Bar under View Formula Bar, or
do it under Tools Options View. HTH Jason Atlanta, GA -----Original Message----- I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions . |
#3
|
|||
|
|||
Maybe you could temporarily hide that formula bar:
View|uncheck formulabar or using the shortcuts: alt-v,f Or maybe make the worksheet window a little smaller so that it doesn't fight with the formula bar. KG wrote: I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions -- Dave Peterson |
#4
|
|||
|
|||
There is no perfect way to do this, because I need to see the formula bar as
well as the cell itself. Temporarily hiding the formula bar seems to be the best compromise. Thanks for the suggestions! "Dave Peterson" wrote: Maybe you could temporarily hide that formula bar: View|uncheck formulabar or using the shortcuts: alt-v,f Or maybe make the worksheet window a little smaller so that it doesn't fight with the formula bar. KG wrote: I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions -- Dave Peterson |
#5
|
|||
|
|||
KG,
Insert a few extra (empty) rows at the top of the sheet. Jack Sons The Netherlands "KG" schreef in bericht ... I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions |
#6
|
|||
|
|||
KG
Work-around could be to enter a WindowSplit at say A5. Select your cell with the long formula in the lower part of the split window. The text in the formula bar would cover just the top part of the split window. Alternative.........reduce the size of the sheet window and move it down far enough to be below the extent of the formula bar. Gord Dibben Excel MVP On Tue, 29 Mar 2005 18:37:58 -0800, "KG" wrote: There is no perfect way to do this, because I need to see the formula bar as well as the cell itself. Temporarily hiding the formula bar seems to be the best compromise. Thanks for the suggestions! "Dave Peterson" wrote: Maybe you could temporarily hide that formula bar: View|uncheck formulabar or using the shortcuts: alt-v,f Or maybe make the worksheet window a little smaller so that it doesn't fight with the formula bar. KG wrote: I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula, the multi-line formula description drops down and obscures the contents of the cell. I presume that there is a way to prevent that from happening, but I couldn't find it in ToolsOptions -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
copy results of formula to another cell | ScheduleQueen | Worksheet Functions | 5 | June 28th, 2004 12:11 AM |
Reset a cell to 0 when a conditional formula is met in another cell | Steve Cohen | Worksheet Functions | 1 | January 6th, 2004 01:04 AM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |