Insert Multiple Rows or Columns In Open Office (Calc) Spreadsheet
(This blog was written for versions of OpenOffice up to Version 3.4.0)
When using an Open Office Calc Spreadsheet additional rows or columns can be inserted by > Insert > and from the Drop Down > Row (or Column). This action can be repeated to insert as many rows or columns as needed.
Alternatively rows and columns can be added by clicking on the icons on the Tool Bar.
If these icons and the associated icons 'Delete Row' 'Delete Column' are not showing on the tool bar they may be added -
Click on the down arrow at the end of a toolbar for a drop down list -
Dock All Toolbars,
Lock Toolbar position,
- Close Toolbar.
Beside the name – Visible Buttons is a side arrow which will show a list of icons and the name of their function that could be on this toolbar. The icons that are already displayed on the toolbar will be shown by a grey background to the icon. Click on any of the icons not already greyed to add them to the toolbar. Click on the 'Insert Rows' 'Insert Columns' 'Delete Row' 'Delete Columns' to add them. These will prove very helpful if using Calc regularly.
To add multiple rows to a Calc sheet select multiple rows where you want the new rows to be. Click the row at one end of the range and Shift+click the row at the other. Then Insert Rows will replace all those rows with new empty ones, moving existing rows down.
The Insert Rows can be done by > Insert > Rows or by
Clicking once on the icon on the tool bar.
Additional columns may be added in the same way by using Insert Columns for as many extra columns are needed.