Adding multiple rows/columns to a spreadsheet in Calc

From NeoWiki

Revision as of 09:28, 5 March 2006 (edit) ( | contribs) ← Previous diff		Current revision (22:58, 23 December 2007) (edit) (undo) Valterb (Talk | contribs) (botlangbar -> IT)
(5 intermediate revisions not shown.)
Line 1:		Line 1:
	=== Inserting more than one row/column at a time ===		=== Inserting more than one row/column at a time ===
-	* To insert multiple rows into a Calc spreadsheet at one time, select the same number of rows as you want to add, beginning at the row AFTER where you want the insertion to be, then ctrl-click/right-click and choose Insert Rows from the contextual menu - or click on the Insert Rows button in your toolbar if it's visible there.	+	* To insert multiple rows into a Calc spreadsheet at one time, select the same number of rows as you want to add, beginning at the row AFTER where you want the insertion to be, then
		+	** Ctrl-click/right-click on the row header (where the row numbers are) within your selection, and choose '''Insert Rows''' from the contextual menu, or
		+	** Click on the "Insert Rows" button in your toolbar (if it's visible there), or
		+	** Choose '''Rows''' from the '''Insert''' menu.
	* To insert multiple columns, just follow the above instructions subtituting 'columns' for 'rows' - it works exactly the same way.		* To insert multiple columns, just follow the above instructions subtituting 'columns' for 'rows' - it works exactly the same way.
		+
		+	{{botlangbarEN|[[De:Mehrere_Zeilen_und_Spalten_zu_Tabellen_hinzufügen|Deutsch]] [[Fr:Insérer_plusieurs_lignes/colonnes_dans_un_tableur|Français]] [[Es:C%c3%b3mo_a%c3%b1adir_varias_filas_o_columnas|Español]] [[It:Aggiungere_righe/colonne_multiple_in_Calc|Italiano]]}}
		+	[[Category:NeoOffice]][[Category:Tips and Hints]]

---

Current revision

Inserting more than one row/column at a time

• To insert multiple rows into a Calc spreadsheet at one time, select the same number of rows as you want to add, beginning at the row AFTER where you want the insertion to be, then
  • Ctrl-click/right-click on the row header (where the row numbers are) within your selection, and choose Insert Rows from the contextual menu, or
  • Click on the "Insert Rows" button in your toolbar (if it's visible there), or
  • Choose Rows from the Insert menu.

• To insert multiple columns, just follow the above instructions subtituting 'columns' for 'rows' - it works exactly the same way.