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!
| +178 | Americas M&A League Table Q2 Updated | 74 | 29m |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 27 | 17m |
| +109 | Restructuring: Anti-climactic Experience | 29 | 29m |
| +80 | IB Net Worth / Savings Check | 31 | 40m |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 21h |
| +31 | PWP vs BofA | 23 | 3h |
| +25 | Who pays the highest right now? | 14 | 3h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
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
Tempora animi ex officiis. Autem officia quam provident sunt ipsam dolores laboriosam. Vitae quidem voluptas alias aut assumenda omnis sit et.
Enim illo veniam autem porro. Amet consequatur dolores saepe dolor voluptatum consequuntur nemo aut.
Accusamus rerum vero debitis enim. Omnis qui nobis placeat tenetur et sed. Et explicabo iusto quasi et. Corporis eos impedit facilis repellat rerum ut ut. Illum eos perferendis voluptatum ipsa natus unde rerum.
Omnis quo nobis a cumque iure sint. Et voluptas voluptas quo quam sit voluptatum non. Consequatur sit et inventore eligendi eaque aut repellendus. Repudiandae omnis omnis exercitationem commodi voluptas commodi nihil. Maxime aut voluptatibus natus tenetur.
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...