Adding multiple rows/columns to a spreadsheet in Calc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 09:35, 5 March 2006 (edit)
( | contribs)
(Inserting more than one row/column at a time)
← Previous diff
Revision as of 22:37, 6 March 2006 (edit) (undo)
Sardisson (Talk | contribs)
m (add menu method)
Next diff →
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 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.+* 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.
 +
 +[[Category:NeoOffice]][[Category:Tips and Hints]]

Revision as of 22:37, 6 March 2006

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.
Personal tools