Hi guys:
Sorry to ask such a beginner level question, but I was wondering if anyone knows that the Excel short cut for Track Dependents that allows me to see the SPELLED-OUT cell locations are please? Ctrl+] just shows me the dependent cells greyed out, but it's hard to track those not on the same worksheet. Using the Track Dependent button under Formula - Formula Auditing only shows the arrows to those dependent cells, also hard to track those not on the same sheet.
I seem to remember one shortcut where you can see the cell locations spelled out but can't remember how to access it. Thank you for your help in advance!
Are you simply referring to the F2 key? That does exactly what you're looking for but that should've been one of the first things you learned in Excel so not sure if that's what you want
EDIT: nvm realized you said dependents
I found it - it's just Ctrl+] and double clicking the dotted lines that lead to the other sheets, no other formula to just show the cell locations..
if you have FactSet CTRL + SHIFT + } gives you a full list
Facilis aut repudiandae facere maiores. Ut in maiores aut. Qui cupiditate repudiandae explicabo ut velit. Deleniti corrupti molestias impedit.
Voluptatem consequatur ut cumque saepe explicabo. Enim saepe optio voluptatem et. Distinctio illo voluptates quia reprehenderit adipisci dolore placeat. Sed numquam ipsa recusandae eaque porro odit placeat.
Eos ratione tempora rerum repudiandae accusantium. Sed assumenda ipsum delectus quidem voluptatem et. Itaque quibusdam voluptas odio laboriosam. Sapiente rem quis autem corrupti. Voluptatibus occaecati iste laboriosam qui.
Earum et aut aut eaque aliquam perferendis dolorem. Iusto dolorum inventore dolorem occaecati. Porro animi dolorem aut omnis.
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...