![]() ![]() Edit formulas - Use the F2 or Alt+E shortcut to modify the audited formula in Point, Enter, or Edit mode, as applicable (these mode names correspond to the text in the bottom left corner of the Excel window, which normally reads "Ready" when not in one of these three input modes). ![]() You can open the Pro Precedents dialog, navigate multiple levels of precedent cells, and close the dialog without ever using your mouse. ![]() Use the left arrow key to move back up one level in the precedents tree. ![]() Press the right arrow key to expand the tree node and trace precedents one level deeper. Node has precedents, it will be marked with a symbol. Drill down - You can also drill down on precedents using intuitive, tree-based navigation.Selecting a precedent cell range in the dialog using the up/down arrow keys or the mouse navigates to the precedent range, whether it is outside of the visible range on the same worksheet, on another worksheet, or even in another workbook. When you activate Pro Precedents, a dialog opens displaying the addresses and values of all cells used in the calculation of the audited cell. Pro Precedents allows you to effortlessly navigate an audited formula's inputs. Macabacus' Pro Precedents and Pro Dependents-the most advanced auditing tools of their kind-make tracing precedents/dependents very simple and are absolutely essential for any power user. You have probably used Excel's native Trace Precedents/Dependents tools and discovered the limitations of their utility. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |