Fellow Excel Monkeys,
I have a quick question regarding the tracing precedents shortcut. For example, let's say we have two sheets called '2010' and '2009' and I currently have a formula on '2010' that is A1+'2009'B1. When I use the trace precedent function, it will show me the A1 on '2010'. Is there a shortcut or way that will show me the B1 cell on the '2009' sheet.
Any tips/pointers would be greatly appreciated. Also, I'm using Excel 2007 if that is any help.
| +133 | Big 4 Hate Propaganda | 47 | 22m | |
| +64 | CVP partners making 8 figures??? | 42 | 5d | |
| +62 | How is working 50/60 hours a week considered relaxed? | 15 | 2m | |
| +33 | Intern hours | 10 | 2d | |
| +32 | Is CB the best "exit" for a career banker | 36 | 4s | |
| +30 | Pros and cons of “low prestige” banks? | 8 | 1d | |
| +26 | Feels like I forget everything | 4 | 6h | |
| +24 | How's this year's intern class? | 8 | 1h | |
| +22 | JPM Global Corporate Bank - how do they work? | 4 | 50m | |
| +21 | Beef between Lazard and PWP | 4 | 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.
ctrl [
Ctrl [ will take me to A1 on '2010'. How can I get it to take me to B1 on the '2009' sheet?
The formula for clarification is in A2 or whatever on '2010'.
if the element that is on the sheet that the function isn't on is first in the formula ctrl [ works (but obviously only for simple formulae), other than that shit outta luck from my end.
Is it even possible to do?
Download this:
http://macabacus.com/macros
Just the lite version is sufficient. The shortcut to trace precedents is (using the Macabacus keyboard shortcut) is: Ctrl Shift [
This will open a little box showing all precedents on any page in your workbook
I presumed I had to download a macro. Thank you very much!
I just F2 the cell, copy the '2009'!B1 part (shift + ctrl + left arrow), then hit F5 and paste. Then to go back to the original tab, just hit F5 then enter.
You can do this very quickly and you don't have to rely on a macro.... Something you may not have say when you have an LBO test at a PE shop or you are using a different computer at a client site, etc, etc
Sequi qui aliquam ex non facere. Voluptates sunt voluptatem tempore omnis quis temporibus amet. Aliquid quae nulla blanditiis dolore est. Quisquam architecto et aliquam aperiam necessitatibus quaerat doloremque. Incidunt et architecto et voluptatem. Repellendus totam ut perspiciatis voluptas qui atque hic.
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...