لطفا منتظر باشید ...
50. Create a Range
49 About Calc Ranges 51 Fill Cells with Data
[View full size image]
TIPGive your ranges meaningful names. The name Payroll05 is obviously a better name than XYZ for payroll data in the year 2005. The better you name ranges, the fewer errors you'll type in your sheets because you'll more accurately refer to cells.Calc keeps track of your ranges and changes them as needed. If you insert a cell in the middle of a range, or even entire rows and columns somewhere inside a range, Calc reassigns the range name to the new cell range. This holds true if you delete cells from a range as well. (If you delete only cell contents, the range is unaffected.)| 1. | Select a Range Click the anchor cell in a range you want to define. While holding down your mouse button, drag your mouse to the last cell in the range. Calc highlights the cells within the range as you drag the mouse.52 About Calc Functions explains how to use functions such as the Sum() function. |
| 5. | Overlap Ranges Two or more cells can appear in different ranges. Depending on the kind of sheet you're creating, overlapping range names can be common. Multiple rows might comprise one range, whereas columns within some of those rows might define a different range. You can name any range you wish, regardless of whether part or all of that range appears in other range names.Name as many ranges as you can because the more range names you create, the less error-prone your sheets will be. By referring to ranges by name, you are less likely to make a mistake than if you reference the cells within that range by their addresses. |
![[View full size image]](/image/library/english/13860_07inf03_alt.jpg;446283){kind=link}