Microsoft Office Tutorials and References
In Depth Information
Creating formulas to calculate values
The following table summarizes many of those shortcuts.
Extend the selection one cell to the right.
Extend the selection one cell to the left.
Extend the selection up one cell.
Extend the selection down one cell.
Extend the selection to the last non-blank cell in the row.
Extend the selection to the first non-blank cell in the row.
Extend the selection to the first non-blank cell in the column.
Extend the selection to the last non-blank cell in the column.
Select the entire active region.
Extend the selection to the beginning of the row.
Extend the selection to the beginning of the worksheet.
Extend the selection to the end of the worksheet.
Extend the selection down one screen.
Extend the selection up one screen.
SEE ALSO For a complete list of keyboard shortcuts, see “Keyboard shortcuts” at the end of
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 in which 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 ).
Relative references are useful when you summarize rows of data and want to use the same
formula for each row. As an example, suppose you have a worksheet with two columns of
data, labeled SalePrice and Rate , and you want to calculate your sales representative’s
commission by multiplying the two values in a row. To calculate the commission for the first sale,
you would enter the formula =A2*B2 in cell C2.