Page 75 - PlusGPT_V2.1_C7_Flipbook
P. 75
Inserting Rows/Columns
To insert a row in a worksheet, follow the given steps:
Step 1: Click the row heading where you want to insert a new row.
Step 2: Click on Insert command in the Cells group under the Home tab.
Step 3: Select the Insert Sheet Rows option from the drop-down list. A new row is inserted above the
selected row and the existing rows shift downwards.
To insert a column in a worksheet, follow the given steps:
Step 1: Click the column heading where you want to insert a new column.
Step 2: Click on Insert command in the Cells group under the Home tab.
Step 3: Click on Insert Sheet Columns. A new column is inserted to the left of the selected cells
and the existing columns shift rightwards.
Inserting a new column
Merging Cells
To merge cells, follow the given steps:
Step 1: Select two or more adjacent cells that you want to merge.
Step 2: Click on Merge & Center command in the Alignment group on Home tab.
Merging cells
The cells will be merged in a row or column, and the cell content will be
center aligned in the merged cell.
Merged Cells
Introduction to Excel 2016 73

