Page 51 - TechPluse_C6_Flipbook
P. 51
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.
Selecting a row
Step 3 Hover mouse pointer over the Insert Rows option. 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.
Selecting a column
Step 4 Select the Columns Before or Columns
After option. A new column is inserted to the left or right of the selected cells and the
existing columns shift rightwards or leftwards.
Selecting a row Selecting a row
MERGING CELLS
Calc allows you to merge multiple cells to make a single cell. Perform the following steps to
merge the selected cells:
More on LibreOffice Calc 49

