Microsoft Office Tutorials and References
In Depth Information
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this topic.
After you create a formula, you can copy it and paste it into another cell. When you do,
Excel tries to change the formula so that it works in the new cells. For instance, suppose
you have a worksheet where cell D8 contains the formula =SUM(C2:C6) . Clicking
cell D8, copying the cell’s contents, and then pasting the result into cell D16 writes
=SUM(C10:C14) into cell D16. Excel has reinterpreted the formula so that it its the
surrounding cells! Excel knows it can reinterpret the cells used in the formula because
the formula uses a relative reference, or a reference that can change if the formula is
copied to another cell. Relative references are written with just the cell row and column
(for example, C14 ).