T
tortuga
Through all the updates of Excel over the years, one annoying flaw never goes
away. When you trace dependencies the dialog box is fixed. You cannot drag
it out to make it larger. So if you have a long formula, the only way to
read through it is go down into the text box and drag your cursor across.
There is no way to see the whole formula all in one view. This is a big
impediment to auditing complex formulas that should be able to be remedied by
simply changing a property on the trace dependencies dialog box
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...8-dc3bb57c69ff&dg=microsoft.public.excel.misc
away. When you trace dependencies the dialog box is fixed. You cannot drag
it out to make it larger. So if you have a long formula, the only way to
read through it is go down into the text box and drag your cursor across.
There is no way to see the whole formula all in one view. This is a big
impediment to auditing complex formulas that should be able to be remedied by
simply changing a property on the trace dependencies dialog box
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...8-dc3bb57c69ff&dg=microsoft.public.excel.misc