## 49. About Calc RangesBEFORE YOU BEGIN 45 Copy and Move Formulas SEE ALSO 50 Create a Range 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. KEY TERM Range One or more cells, selected adjacent to each other in a rectangular manner, that you can name and treat as a single entity or group of cells in formulas. 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 Anchor point One corner of a range of cells; typically, the upper-left cell in a range is considered the anchor point, although any of the four corner cells can be considered an anchor point also. A sheet can have multiple ranges selected at one time. 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. ( 50 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. 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 TIP Range names are absolute. If a formula in one cell refers to a range named After you assign a name to a range, you don't have to remember that range's address, such as |

Sams Teach Yourself OpenOffice.org 2, Firefox and Thunderbird for Windows All in One

ISBN: 0672328089

EAN: 2147483647

EAN: 2147483647

Year: 2005

Pages: 232

Pages: 232

Authors: Greg Perry

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