Trace Precedents Function
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.
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
Sit unde eum ullam velit ipsum. Atque facilis exercitationem facere enim quia.
Dolorem nemo minus in nihil fugit iste voluptas. Qui velit modi eos enim delectus nesciunt.
Qui nemo quia in voluptas autem. Qui eaque nostrum dolores reiciendis sit fugiat. Enim quasi accusamus tempore et consectetur sint dolore.
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...