Excel Tip of the Week: Tracing Precedents

Today’s topic is tracing precedents.

Sometimes spreadsheets can get really big and formulas become very complicated. In those situations it can be hard to tell exactly which cell a formula is referring to. Excel gives you a few ways to deal with this situation.

One way is to use the “trace precedents” option. If you use the trace precedents feature, Excel will insert arrows into the spreadsheet to show you which cells are being used in the function. Here is a picture of a very basic example:

To use this feature, click the “Formulas” menu on the ribbon and then from the “Formula Auditing” group click on “Trace Precedents.”(PC Keyboard shortcut: Alt → M → P)

Here is an example if some of your data is on another worksheet:

You’re able to trace as many precedents as you like and fill up your entire spreadsheet with arrows, but once you’re ready to get rid of the arrows you can use the “Remove Arrows” feature.

To do this, click the “Formulas” menu and then from the “Formula Auditing” group click on “Remove Arrows” (PC Keyboard shortcut: Alt → M → A → A).

About Doug Midkiff

I’m really good at Excel. I’m also a Texan, which seems to be a trend among OwenBloggers these days (you can’t stop us, you can only hope to contain us). After graduating from Texas, (Hook’em) I spent four years as a financial analyst before finding my way to Owen where I’m concentrating in finance with an emphasis on real estate. I love my wife, indie coffee shops, disc golf, soccer, web comics, Google maps, urbanism, sustainability, and warm weather.
This entry was posted in Doug Midkiff '12, Excel Tip of the Week. Bookmark the permalink.

16 Responses to Excel Tip of the Week: Tracing Precedents

  1. Wonderful website you have here but I was wondering if you knew of any discussion boards that cover the same topics discussed here? I’d really love to be a part of community where I can get opinions from other knowledgeable people that share the same interest. If you have any suggestions, please let me know. Cheers!
    tiffany infinity necklace http://sweatcollection.com/wp-content/themes/maya/css/unoslider-themes/slick/tiffany-store.php

  2. grade says:

    Hi there colleagues, how is all, and what you want to say concerning this paragraph, in my view its truly amazing designed for me.

  3. Buy wholesale Oilers cheap jerseys Paypal

  4. Hvis du ønsker at suge i den kinesiske kultur, nyde eksotiske retter og dase i viden om kinesiske arv, så Beijing er den bedste destination. Men planlægningen for en by som Beijing, hvor sproget er en barriere, er du nødt til at stole på nogen, erfarne og troværdige. Og her kommer Beijing Private Tour Guide på din tjeneste. Beijing Private Tour Guide er en online rejsebureau drives af Fiona, som vil være din guide i Beijing Tourism. Fiona er en Localite og har været guide for Beijing ture siden 2008. Fionas USP er, at hun er certificeret engelsktalende guide, som gør dit ophold i Beijing meget glat. Hun tilbyder privat guide service, hvor du kan slukke din tørst for den kinesiske historie. Hertil kommer, hvis du har nogen særlig liste over de steder, du ønsker at se, så Fiona vil sørge for et skræddersyet tour. Med sin erfaring på fem år, kender Fiona de lokale varianter og kun de rigtige steder, at du vil nyde med din familie og venner. Hendes rute af de ting at gøre i Beijing ture afspejler hendes kendskab til turist følelser. Du kan opdele dine Beijing ture i to eller tre dele. Fiona? S erfaring som rejseleder vil komme i handy, når du besøger Den Himmelske Freds Plads, den største plads i Beijing eller Ming gravene, som er den gravplads for de 13 Ming kejsere. Du vil også besøge Himlens Tempel, som er det største tilbede tempel i Kina. Bortset fra, at den første dag, vil du også besøge Den Forbudte By, der huser de kejserlige paladser af 24 Ming og Qing. Der er et ordsprog i Kina omkring Den Kinesiske Mur i Kina – “Du er ikke en rigtig helt, indtil du har nået toppen af ​​muren”. Nå, det gælder, hvis du ikke besøge en af ​​de største vidundere i verden. Fiona vil tage dig gennem historien om de kinesiske dynastier, som Den Kinesiske Mur i Kina har været et stille vidne. Tag den store mur tour på væggen og nyd det store majestætiske skabelse. På dag to, Fiona vise dig den reelle Beijing Tourism. Hun vil tage dig gennem de travle Hutougs der er fyldt med mennesker, der går om deres daglige virksomhed. Du vil også se Luilichang Cultural Street og Panjiyuan marked, er berømt for sin udstilling af den kinesiske traditioner og kultur. Du vil også se Lama-templet, den største tibetanske templet. Hvis du har børn, har derefter Beijing Private Tour Guide inkluderet noget i det for at gøre Beijing tours interessant for dem også. Du vil se Beijing Zoo og Olympic Park, noget, som børnene vil nyde. På den sidste del af turen, vil Fiona tage dig gennem den bedste gade mad i Beijing ture. Du vil blive behandlet med den traditionelle Peking duck og kinesiske Hot-pot. Du kan tilbringe din eftermiddag nyder shopping på Silk Street, Yashow marked og Hongqiao Pearl marked. Om aftenen kan Beijing Private Tour Guide arrangere shows som Pecking Opera.

  5. Daniel says:

    Hello, just wanted to tell you, I enjoyed this blog post.
    It was funny. Keep on posting!

  6. Well I sincerely enjoyed reading it. This article offered by you is very useful for proper planning.

  7. Nos corps sont des machines, nous fournissons carburant pour notre machine de fonctionner aussi efficacement que possible (la nourriture) et nous nous assurons que notre machine est huil茅e avant de l’utiliser (茅chauffement 茅tirement), mais il ne faut pas oublier la maintenance standard pour aider 脿 continuer notre machine 脿 fonctionner correctement (r茅cup茅ration). La r茅cup茅ration est une partie tr猫s importante de notre programme. Boire suffisamment d’eau, bon apr猫s wod nutrition et le repos sont tous des 茅l茅ments de r茅cup茅ration. Souvent, apr猫s le WOD nous avons d’utiliser les rouleaux de mousse et / ou points de d茅clenchement des boules dans le cadre de votre refroidissement. Je vous encourage 脿 examiner cette partie de votre WOD. Il est tout aussi important que l’entra卯nement lui-m锚me!

  8. paydayloans says:

    Whɑt’s Taking placе i am new to tҺis, I stumbled upon this I’ve discovered It positively սseful aոd іt has helped mе
    oսt loads. I am hoping to give a contribution & Һelp differeոt customers like its hhelped mе.

    Great job.

  9. Hey there! Do you employ Twitter? I’d want to follow an individual if that would be ok. I’m without doubt enjoying your blog and enjoy new content.
    wholesale nba jerseys http://tariswenson.webs.com/nba

  10. bottes ugg says:

    serial number,58 sur iTespressoCPU-Z est un utilitaire gratuit qui vous fournit des informations sur les principaux composants de votre syst

  11. to be officially recognised as English football’s most successful team domestically.Police said the death is being treated as unexplained. as he returned home from work.Follow with a couple of kiwi fruits.5. The Stone Roses and Happy Mondays the Geordie plants – who were subjected to Geordie Shore,

  12. Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you an email. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it develop over time.|

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>