Inserting a line break in a cell

From NeoWiki

Revision as of 21:24, 12 February 2007 (edit) Sardisson (Talk | contribs) (start this, because I need this hint ;)) ← Previous diff		Current revision (12:25, 25 April 2007) (edit) (undo) Jgd (Talk | contribs) m (→Automatic line breaks in a range of cells -typo)
(3 intermediate revisions not shown.)
Line 1:		Line 1:
-	{{inTranslation}}
-
	===Inserting a line break in a spreadsheet cell===		===Inserting a line break in a spreadsheet cell===
	* To insert a line break in a spreadsheet cell:		* To insert a line break in a spreadsheet cell:
-	** Double-cliquez sur la cellule.	+	** Double-click on the cell in which you want to insert the line break.
-	** Placez le curseur dans la cellule, à l'endroit où vous voulez insérer le retour à la ligne	+	** Place the cursor in the cell at the position where you want to insert the line break.
-	** Pressez les touches {{key|Cmd+Entrée}}	+	** Press {{key|Cmd-Return}}.
-	'''N.B''' : Cela ne fonctionne pas si le curseur est dans la ligne de saisie, en haut de l'écran. Il doit être dans la cellule considérée.	+	'''N.B''': This will not work if the cursor is in the input line at the top of the spreadsheet. The cursor must be in the cell itself.
-	===Retour à la ligne automatique dans une plage de cellules===	+	===Automatic line breaks in a range of cells===
-	Sélectionnez la plage de cellules dans laquelle vous voulez insérer un retour à la ligne automatique. Puis choisissez le sous-menu {{menu|Format/Cellules}}. Cliquez sur {{section|Alignement}} et cochez la case {{prefName|Renvoi à la ligne automatique}} et éventuellement {{prefName|Coupure des mots active}} dans la section {{section|Propriétés}}.	+	Select the range of cells in which you want to insert an automatic line break. Then choose the {{menu|Cells…}} item from the {{menu|Format}} menu. Click on the {{section|Alignment}} tab, and in the {{section|Properties}} section, check the {{prefName|Wrap text automatically}} box (and possibly the {{prefName|Hyphenation active}} box as well).
-	===Insertion d'un retour à la ligne dans une cellule de tableau d'un document Writer===	+	===Inserting a line break in a cell in a table in Writer===
-	Un retour à la ligne dans une cellule de tableau d'un document de texte s'insère en pressant la touche Entrée, comme dans un texte ordinaire. Si le texte dépasse la largeur de la cellule, le retour à la ligne s'insére automatiquement.	+	A line break in a table cell in a Writer document can be inserted simply by pressing {{key|Return}}, just like in normal text. If the text in the cell exceeds the width of the cell, a line break is inserted automatically.
-	{{botlangbarEN|[[Fr:Insérer un Retour Ligne dans une Cellule|Français]][[It:Inserire_un_a_capo_all%27interno_di_una_cella_in_Calc|Italiano]]}}	+	{{botlangbarEN|[[Fr:Insérer un Retour Ligne dans une Cellule|Français]] [[It:Inserire_un_a_capo_all%27interno_di_una_cella_in_Calc|Italiano]] [[Es:C%c3%b3mo_insertar_saltos_de_l%c3%adnea_en_una_celda|Español]]}}
-	[[Category:NeoWikiFR]]	+	[[Category:NeoOffice]][[Category:Tips and Hints]]

---

Current revision

Inserting a line break in a spreadsheet cell

• To insert a line break in a spreadsheet cell:
  • Double-click on the cell in which you want to insert the line break.
  • Place the cursor in the cell at the position where you want to insert the line break.
  • Press Cmd-Return.

N.B: This will not work if the cursor is in the input line at the top of the spreadsheet. The cursor must be in the cell itself.

Automatic line breaks in a range of cells

Select the range of cells in which you want to insert an automatic line break. Then choose the Cells… item from the Format menu. Click on the Alignment tab, and in the Properties section, check the Wrap text automatically box (and possibly the Hyphenation active box as well).

Inserting a line break in a cell in a table in Writer

A line break in a table cell in a Writer document can be inserted simply by pressing Return, just like in normal text. If the text in the cell exceeds the width of the cell, a line break is inserted automatically.