ADM 1370 Lecture Notes - Lecture 11: Portable Document Format, Railways Act 1921, Emv
11 Oct 2018
School
Department
Course
Professor
Document Summary
In the formula auditing group, click show formulas. Alternatively, you can use the following key combination: hold ctrl & press ~ Trace cells the provide data to a formula (precedents) Select the cell that contains the formula for which you want to nd precedent cells. To display a tracer arrow to each cell that directly provides data to the achieve cell, on the formula tab, in the formula auditing group, click trace precedents. Trace formulas that reference a particular cell (dependents) Select the cell for which you want to identify the depended cells. To display a tracer arrow to each cell that is dependent on the active cell, on the formula tab, in the formula auditing group, click trace dependents. Cell addresses that are adjusted as a formula containing these addresses is copied within the spreadsheet. B6 copied over two columns to the right will become d6.
