HELP!
It would really make my life easier if there was a shortcut which allowed me to follow through a formula and took me to the cell that it is pointing to.
More detail - so I have a spreadsheet with two tabs. One tab (called Costs) has formulas in it, one with data (called SAP). The formulas point to the data. An example of a formula used in the Cost tab is =SUM(SAP!T102+SAP!T109+SAP!T110)
I am aware of the shortcut CTRL+[ which does allow me to 'follow through' to that cell on the linked tab, however where there are numerous cells (as in formula above) it only ever sends me to the first cell (SAP!T102 in my example)
Ideally I would like it to highlight all three cells
Any ideas?![]()
Bookmarks