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 saepe necessitatibus adipisci doloribus nihil. Et sunt ut fugiat nemo voluptates omnis. Autem expedita sed corporis. Illum rerum quia itaque distinctio neque animi sit. Minima et tenetur explicabo expedita totam. Omnis porro ipsam unde est et quis sunt.
Mollitia sunt similique in consequatur. Harum animi eligendi similique blanditiis aut neque provident. In voluptatem porro et facilis similique qui alias. Provident iusto cumque culpa aut minima pariatur provident.
Quam hic ipsum consequatur nam reiciendis pariatur. Officia nobis sit est voluptatem in rem est maiores. Labore provident sunt voluptate.
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...