Microsoft Office Tutorials and References
In Depth Information
Creating formulas to calculate values
The following table summarizes many of those shortcuts.
Key sequence
Description
Shift+Right Arrow
Extend the selection one cell to the right.
Shift+Left Arrow
Extend the selection one cell to the left.
Shift+Up Arrow
Extend the selection up one cell.
Shift+Down Arrow
Extend the selection down one cell.
Ctrl+Shift+Right Arrow
Extend the selection to the last non-blank cell in the row.
Ctrl+Shift+Left Arrow
Extend the selection to the first non-blank cell in the row.
Ctrl+Shift+Up Arrow
Extend the selection to the first non-blank cell in the column.
Ctrl+Shift+Down Arrow
Extend the selection to the last non-blank cell in the column.
Ctrl+*
Select the entire active region.
Shif t+Home
Extend the selection to the beginning of the row.
Ctrl+Shift+Home
Extend the selection to the beginning of the worksheet.
Ctrl+Shift+End
Extend the selection to the end of the worksheet.
Shift+Page Down
Extend the selection down one screen.
Shift+Page Up
Extend the selection up one screen.
SEE ALSO For a complete list of keyboard shortcuts, see “Keyboard shortcuts” at the end 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 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.
Search JabSto ::




Custom Search