Selecting and Filling a Cell Range

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 21:08, 2 March 2007 (edit)
Jgd (Talk | contribs)
(botlangbar -> It)
← Previous diff
Revision as of 22:31, 2 March 2007 (edit) (undo)
Sardisson (Talk | contribs)
(some initial polish)
Next diff →
Line 1: Line 1:
{{Fixme}} {{Fixme}}
-==Selection and Filling of a cell range==+==Selecting and Filling a Range of Cells==
-===Selection of a range===+Sometimes you might wish to fill an entire row or column in your spreadsheet with data “automatically,” e.g., sequential dates or numbers. You can do this in NeoOffice using the following steps:
 + 
 +===Selecting a range===
[[Image:Range_names.png|right]] [[Image:Range_names.png|right]]
-* In the input field in the left top of the sheet, type the name of the beginning cell then the name of the ending cell of the range which you want to select. The names must be separated with a semi-colon: e.g. A1:A20 and press {{key|Enter}}+* In the “Input field” in the left top of the sheet, type the name of the beginning cell and then the name of the ending cell of the desired range, separated by a colon (<tt>:</tt>), e.g. <tt>A1:A20</tt>, and press the {{key|Enter}} key. <br />You can also select the range with the mouse, or by clicking in the top-left cell in the range and shift-clicking in the bottom right cell in the range, if you do not have the cell references memorized.
-* You can save that range by giving it a significant name selecting the {{menu|Insert}} menu then the {{menu|Names}} sub-menu and the {{menu|Define…}} item. This name will be visible dans la section {{section|Range names}} in the {{window|Navigator}} window. <br>+* You can save that range for easier future use by giving it a significant name. Open the {{menu|Insert}} menu, then the {{menu|Names}} sub-menu, and select the {{menu|Define…}} item. Type in a name and press {{button|Add}}. (This name will now be visible in the {{section|Range names}} section in the {{window|Navigator}} window.)<br />Afterwards, it will be easy to select the range by double-clicking its name in the {{section|Range names}} section in the {{window|Navigator}}.
-Afterwards, it will be easy to select the range by double-clicking its name in the {{section|Range names}}section in the{{window|Navigator}}. +
===Filling a range=== ===Filling a range===
Line 29: Line 30:
==Showing the formulas== ==Showing the formulas==
-If in the {{section|View}} section of {{section|NeoOffice Calc}} of the {{menu|Preferences}} sub-menu of the {{menu|NeoOffice}} menu, you check the {{prefName|Value highlighting}} option, the cells which contain values will be displayed in blue, and those which contain formulas in green. If you choose that option, you'll not be able to change the character color in those cells.+If in the {{section|View}} section of {{section|NeoOffice Calc}} of the {{menu|Preferences}} sub-menu of the {{menu|NeoOffice}} menu, you check the {{prefName|Value highlighting}} option, the cells which contain values will be displayed in blue, and those which contain formulas in green. If you choose that option, you'll not be able to change the character color in those cells.
{{botlangbarEN|[[Fr:Sélection et remplissage d'une plage de cellules|Français]] [[It:Selezione_e_Compilazione_di_un%27Area_di_Celle|Italiano]]}} {{botlangbarEN|[[Fr:Sélection et remplissage d'une plage de cellules|Français]] [[It:Selezione_e_Compilazione_di_un%27Area_di_Celle|Italiano]]}}
[[Category:NeoOffice]][[Category:Tips and Hints]] [[Category:NeoOffice]][[Category:Tips and Hints]]

Revision as of 22:31, 2 March 2007

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

Contents

Selecting and Filling a Range of Cells

Sometimes you might wish to fill an entire row or column in your spreadsheet with data “automatically,” e.g., sequential dates or numbers. You can do this in NeoOffice using the following steps:

Selecting a range

  • In the “Input field” in the left top of the sheet, type the name of the beginning cell and then the name of the ending cell of the desired range, separated by a colon (:), e.g. A1:A20, and press the Enter key.
    You can also select the range with the mouse, or by clicking in the top-left cell in the range and shift-clicking in the bottom right cell in the range, if you do not have the cell references memorized.
  • You can save that range for easier future use by giving it a significant name. Open the Insert menu, then the Names sub-menu, and select the Define… item. Type in a name and press Add. (This name will now be visible in the Range names section in the Navigator window.)
    Afterwards, it will be easy to select the range by double-clicking its name in the Range names section in the Navigator.

Filling a range

  • Select a cell range and choose the Edit menu then the Fill sub-menu and the Series… item.

Four types of series Linear, Growth, Date and AutoFill are available.

  • The automatic filling is done from a sort list. You can see all the available lists by selecting Sort Lists in the NeoOffice Calc section of the Preferences sub-menu of the NeoOffice menu.

You can add here your personal lists:

  • Click New
    • Enter the successive values of your list, separated with a line break. Click OK
    • That serie will be available via the Series… item in the Fill sub-menu of the Edit menu by checking the case AutoFill in the Series type section and choosing the first element of the list as the Start value.

Copying formulas

  • The Fill function allows you to apply a recurrent formula to a cell range.

Example :

  • Select the range A1:A20, enter 1 in A, choose the Edit menu then the Fill sub-menu, click Serie.
  • Set up the Type to Linear, the Start value to 1, the End value to 20 and theIncrement to 1.
  • Click OK.

The serie of the first 20 integers appears in the selected range.

  • Enter 1 in the cell B1.
  • Select the cell B2 and enter in the formula line, in the top of the page : "=B1+A2" (without quotes). Press Enter. The sum 3 appears in the cell B2.
  • Select the range B2:B20, choose the Edit then the Fill sub-menu and the Down item. Now every cell of the selected range contains the sum of the successive integers and the cell B20 contains the sum of the first 20 integers, i.e. 210.

Showing the formulas

If in the View section of NeoOffice Calc of the Preferences sub-menu of the NeoOffice menu, you check the Value highlighting option, the cells which contain values will be displayed in blue, and those which contain formulas in green. If you choose that option, you'll not be able to change the character color in those cells.


This article in other languages: Français Italiano
Personal tools