Use Ctrl Easily Navigate cells
When you're debugging a worksheet, you can easily navigate through all the cells referenced in a formula.
- Highlight the cell and press Ctrl-[ (that's Ctrl-open-square-bracket).
- Excel highlights all the cells referenced by the formula, and moves the current selection to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell
- Continue to press Enter to move though the rest of the referenc
No comments:
Post a Comment