Inserting Columns and Rows
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
- What is Calc?
- Spreadsheets, Sheets, and Cells
- Parts of the Main Calc Window
- Starting New Spreadsheets
- Opening Existing Spreadsheets
- Opening CSV Files
- Saving Spreadsheets
- Password Protection
- Navigating within Spreadsheets
- Selecting Items in a Sheet or Spreadsheet
- Working with Columns and Rows
- Working with Sheets
- Viewing Calc
- Using the Navigator
- Using Document Properties
Inserting Columns and Rows
Columns and rows can be inserted individually or in groups.
 |
When you insert a single new column, it is inserted to the left of the highlighted column. When you insert a single new row, it is inserted above the highlighted row. Cells in the new columns or rows are formatted like the corresponding cells in the column or row before (or to the left of) which the new column or row is inserted. |
Single column or row
Using the Insert menu:
- Select the cell, column, or row where you want the new column or row inserted.
- Choose either Insert → Columns or Insert → Rows.
Using the mouse:
- Select the cell, column, or row where you want the new column or row inserted.
- Right-click the header of the column or row.
- Choose Insert → Rows or Insert → Columns.
Multiple columns or rows
Multiple columns or rows can be inserted simultaneously rather than one at a time.
- Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
- Proceed as for inserting a single column or row above.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
