< Day Day Up > |

A selected group of cells comprises a range . A range is always rectangular, and it might be a single cell , a row, a column, or several adjacent rows and columns . The cells within a range are always contiguous, but you can select multiple ranges at the same time. You can perform various operations on ranges, such as moving and copying. If, for example, you want to format a row of totals in some way, you first select the range that includes the totals and then apply the format to that range. Before You Begin 44 Copy and Move Formulas See Also 49 Create a Range The next figure shows three selected ranges on a sheet. You can describe a range by the cell reference of the upper-left cell of the range (the anchor point ) and the cell reference of the lower-right cell of the range. As you can see from the figure, multiple-celled ranges are designated by listing the anchor point, followed by a colon (:), followed by the range's lower-right cell reference. Therefore, the range that begins at KEY TERM
A sheet can have multiple ranges selected at one time. KEY TERM
Keep in mind that a single cell, if selected, can be considered a range. So, The true power of Calc shows when you use ranges of cells, as opposed to specifying every individual cell, in formulas. ( 49 Create a Range explains how to name ranges.) Instead of referring to the range All the following are valid formulas. Cell references or range names appear throughout the formulas: =(SalesTotals)/NumOfSales =C4 * 2 - (Rate * .08) =7 + LE51 - (Gross - Net) When you enter formulas that contain range references, you can either type the full reference or point to the cell reference. If you want to include a complete named range in a formula (formulas can work on complete ranges), select the entire range, and Calc inserts the range name in your formula. Often, finding and pointing to a value is easier than locating the reference and entering it exactly. TIP
If, for example, you are entering a formula, when you get to the place in the formula that requires a cell reference, don't type the cell reference (such as After you assign a name to a range, you don't have to remember that range's address, such as |

< Day Day Up > |

Sams Teach Yourself OpenOffice.org All In One

ISBN: 0672326183

EAN: 2147483647

EAN: 2147483647

Year: 2003

Pages: 205

Pages: 205

Authors: Greg Perry

Similar book on Amazon

flylib.com © 2008-2017.

If you may any questions please contact us: flylib@qtcs.net

If you may any questions please contact us: flylib@qtcs.net