Insert / Add Column in Spreadsheet

How to insert or add column in OpenOffice Spreadsheet?

Explanation

There are two options to insert a single column,
Option 1:
Step 1:
Click on the cell where you want to add a new column.
Step 2: Right click → Insert
insert row
Step 3: Select → Entire Column then click OK
The column will be inserted to the left side of the selected cell.
insert column
Option 2:
Step 1: Click on the cell where you want to insert a new column.
Step 2: Select InsertColumns
insert column2
Option 3:
Right click on the column header and select InsertColumns
insert column3
The column will be inserted as given in the below image,
insert column1

Related Topics