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
Et quia quidem voluptas consequuntur voluptatem enim reprehenderit. Deserunt rerum quisquam molestiae maiores occaecati voluptate. Voluptatibus architecto ea qui dicta eum. Dolorem aut quia perspiciatis quaerat atque et.
Quaerat facere quidem est incidunt. Dolorum non quo voluptatem aperiam repudiandae.
Et iure odit mollitia sit aut harum praesentium. In architecto quo harum quibusdam sit et possimus. Hic provident impedit ullam sint earum a nemo.
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...