Page 47 - Touchpad_Plus_V3.2_Class 6
P. 47
INSERTING ROWS/COLUMNS
LibreOffice Calc allows you to insert rows and columns in a worksheet according to your
requirement.
Inserting Rows
To insert a row in a worksheet, follow these steps:
Step 1 Click and select the row heading where you want to
insert a new row.
Step 2 Click on the Sheet menu.
Step 3 Hover mouse pointer over the Insert Rows option.
Selecting a row
A submenu appears.
Step 4 Select the Rows Above or Rows Below option. A new row is inserted above or
below the selected row and the existing rows shift downwards or upwards as the case
may be.
Inserting a new row New row inserted
Inserting Columns
To insert a column in a worksheet, follow these steps:
Step 1 Click and select the column heading where you want
to insert a new column.
Step 2 Click on the Sheet menu.
Step 3 Hover mouse pointer over Insert Columns option. A
submenu appears.
Step 4 Select the Columns Before or Columns After option. Selecting a column
A new column is inserted to the left or right of the selected cells and the existing
columns shift rightwards or leftwards.
Selecting a column New column inserted
More on LibreOffice Calc 45

