Top Answer
User Avatar
Wiki User
2010-03-05 10:01:18
2010-03-05 10:01:18

It works basicly the same way in both versions, but the commands are in different locations. The command is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003.

See related links for an animated tutor of how to use trace precedents.


Related Questions

With the cell(s) selected, pressing Ctrl and the [ key will trace the direct precedents. Press shift too and you will get the precedents of those precedents of all precedents for the selected cell(s).

You use the auditing tools, which include the trace precedents and trace dependents commands.

the differences between a macromineral and a trace element is that their is no difference they both has something to do with the health

You can use the Formula Auditng which includes the Evaluate facility and Trace Precedents, which would be useful.

Precedents are the cells that a formula uses. Say you have the following formula in a cell: =A2+C12-D10 Then the cells A2, C12 and D10 are the precedents of the formula. The formula is using values that are in them. You use Trace Precedents to find those cells and highlight them on the Spreadsheet. If you are having a problem with formulas you can highlight the cells to be able to see which ones are being used. One way of doing it is to select the cell and then press the CTRL key and also the [ key. You can also use the Auditing toolbar to do it.

Trace Error shows you the cells that are referenced by a formula that has an error. With a cell with an error highlighted, clicking on the Trace Error button will show arrows indicating links between cells which can help you trace the error. You can then check what cells are referenced and see can you find which one may be causing your error.

You can use Formula Auditing, specifically the Trace Precedents facility.

comet is mainly ice, and so it leaves a trace as it gets close to the sun. meteors is not made of ice, but made of metal, solids, rocks, anything that doesn't melt easily and so it does not leave a trace or particles behind.

This question is not clear. To find cells that contain currency, you can search for the money symbol (e.g. $).

Archaeologists have used certain strategies to trace socio-economic differences in Harappan society which includes studying burials. The dead in Harappan society were laid in pits. The differences in the way the burial pits were made and their contents could indicate social differences while others did not.Posted By Ryan Stritzinger

You use a facility called formula auditing. You can then use Trace Precedents to see what cells are referenced by a formula. You use Trace Dependents to see which cells use the active cell. You can also press Ctrl and the [ key to trace precendents and Ctrl and the ] key to trace dependents.

Write difference in the form of a table between Ping and Trace Route command?

The ribosomes of chloroplasts closely resemble bacterial ribosomes, while mitochondrial ribosomes show both similarities and differences that make their origin more difficult to trace.

A trace fossil was an imprint left behind by an animal that hardens and turns to stone

It will show you the cells that are referenced by a formula that has an error. This can be done by using arrows on the worksheet. With a cell with an error highlighted, clicking on the Trace Error button will show these arrows. You can then check what cells are referenced and see can you find which one may be causing your error.

Without a Trace - 2002 Between the Cracks 1-4 is rated/received certificates of: Netherlands:6

trace elemnts are neded only in samll quanties whil essentials are necessary for lvine

pseudocode is a sentence-like representation of a piece of code while a trace table is a technique used to test a algorithms.

a stencil is a tracing paper which has different pictures you can trace. for example this animal he is a cut out for tracing in between of the animal is cut out so you can trace from inside it.

Terrestrial planets are rocky bodies whereas the giant planets consist mostly of gasses with trace amounts of solids. This is due to the fact that the heavier elements were pulled closer to the sun via gravity.

A macro mineral is needed in large quantities whereas trace elements are minerals required in small quantities

The Catholic religion is the original Christian religion. All other Christian denominations can trace their roots back to the Catholic Church. Since there are about 33,000 Protestant denominations, it would be impossible here to discuss all the differences.

You go to Formula Auditing and use Trace Dependents. You can also select the cell and press the Ctrl and ] keys.

Shane Trace goes by Trace.

There are a lot if differences than similarites in the book,first of all mullet fingers is a runaway in booth and kids attend trace middle

Copyright ยฉ 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.