* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here. Ivy - * Beware of scammers posting fake support numbers here. Your cooperation and understanding are highly appreciated. This is the best way to report issue and get feedback from You submit the feedback within Excel to send this issue report directly to the Click the black arrow to display the Go To Dialog. If a dependent cell is on another worksheet, a black arrow appears pointing to a little icon. We appreciate your efforts on thisĬase, and we are sorry for the confusion caused by this. When a cell has a dependent cell and you use Trace Dependents, Excel puts an arrow to each dependent cell, and goes one layer deeper with each click of Trace Dependents. Matter what, only the relationships from A1 will appear when we click Trace Dependentsīased on this article, it should show the relationshipīetween the cells within the range you select. We also test the same behavior in Excel for Windows. Moreover, if I select all ranges and then click Traceĭependents button at this time, all the arrows will appear. However, if I select some specific range which has formula, If I select all ranges of this sheet, then click Traceĭependents button, only the arrow from cell A1 will appear. Based on your description, we tested in the same version ofĮxcel for Mac.
0 Comments
Leave a Reply. |