Page 25 - Plus_V2.2_C6_Flipbook
P. 25
At times, a cell might display #####. This can occur when the cell contains a number or a date that
exceeds the width of the cell so it cannot display all the characters that its format requires.
To see the entire contents of the cell with its current format, you must increase the width of the column.
INSERTING ROWS/COLUMNS
To insert a row in a worksheet, follow these steps:
Step 1: Click the row heading where you want to insert a new row.
Step 2: Click on Insert command under the Cells group on the Home tab.
Step 3: Select the Insert Sheet Rows option from the drop-down list.
Inserting a new row
A new row will be inserted above the selected row.
To insert a column in a worksheet, follow these steps:
Step 1: Click the column heading where you want to insert a new column.
Step 2: Click on Insert command on the Home tab.
Step 3: Click on Insert Sheet Columns.
Inserting a new column
A new column will be inserted to the left of the selected column.
MERGING CELLS
While working on Excel you might need
to combine some cells to show a part of
data under one heading. Combining two
Merged Cells
or more cells is known as Merging. To
merge cells, follow these steps:
Step 1: Select two or more adjacent cells that you want to merge. Merging cells
Step 2: Click on Merge & Center command in the Alignment group on Home tab.
The cells will be merged in a row or column, and the cell content will be centered in the merged cell.
More on Excel 2016 23

