Let's say I am looking at the following formula in a cell: =('Page 1'!I282)*('Page 2'!A100).
If I want to see the precedent, I hit CTRL + [. But this will only take me to the first term. How can I see the second term without hitting F5 & pasting in 'Page 2'!A100?
Is there a way to determine which term in the formula to see, aside from F5? Imagine the equation had multiple terms...
Thx everyone!
| +266 | UBS Tech MD hires Son (from no-name college) as an Intern | 48 | 7h |
| +166 | WTF IS THIS COMPETITON | 59 | 13h |
| +161 | Mayday, Mayday: Key UBS Leaders (Former Barclays MDs) Abandoning Ship | 28 | 3d |
| +118 | Is banking in the south more sustainable? | 28 | 9h |
| +94 | The Intern Starter Pack | 16 | 5m |
| +75 | Current State of the League Tables | 28 | 14h |
| +51 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 9 | 8h |
| +49 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 31 | 1d |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 1d |
| +32 | PWP Layoffs????? | 18 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Tab, if I'm not mistaken.
How would that work, exactly? Normally, I go to the cell, hit F2 to see what's going. If I want to drill down, I hit CTRL+[ to see what the terms of the equation actually refer to. The only problem is, using CTRL+[, I can only drill into one term. At what point would I hit the Tab key to drill into the second (third, forth, fifth, etc..) term of the equation?
Thanks again
Formulas > Formula auditing > Trace precedents / dependents
or Alt+M+D or Alt+M+P
Who would'a thunk it, I've been carrying over Alt T U T from '03 for all this time.
Please stop saying drill down.
no
deal maven shourtcuts ftw. Ctrl + Shift + [
Worked like a charm, thanks very much. Is this exclusively a Cap IQ function though? When I hit CTRL + Shift + [, it activates 'cap IQ trace'...I assume this means those without the cap iq plugin cannot use this?
I'll take this opportunity to throw another question out: when you double-click the Format Painter, you can apply the same format to multiple cells at once. Is there a keyboard shortcut for this? I know the keyboard shortcut to make a single-cell format adjustment (alt+h+fp), but this only allows me to modify an adjacent cell... Thoughts here are also appreciated!
Similar shortcut for factset. i would die without it
Yeah you have to have factset or capiq addin on your computer for any ctrl + shift shortcuts to work. They are very helpful so I would encourage you at least look up all of them.
As far as copying formats just ctrl + c on the cell you want then select the cells you want and paste special format ( alt + es + t) on them.
Thanks man...much appreciated
Eum et ullam ut voluptate qui modi. Quia doloribus eveniet est ex.
Nihil distinctio beatae dolor libero et. Quidem quia explicabo eaque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...