![]() ![]() Figure 3.3 Relative References – Displayed as calculations. ![]() ![]() Pressing Ctrl ~ a second time will display your calculations in the default view – as values. ![]() Want to see all the calculations you have just created? Press Ctrl ~ (See Figure 3.3.) Ctrl ~ displays your calculations (formulas). You wouldn’t want column N to display an answer that uses the values in column L. These cell references are relative references.īy default, the calculations that Excel copies change their cell references relative to the row or column you copy them to. The calculation in column B reads: =MAX(B5:B24). Note that as you copy the calculation from one column to the next, the cell references change.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |