Page 33 - ModularV1.1 _c7_flipbook
P. 33
Clickipedia
At times, a cell might display #####. This can occur when the cell contains a number or
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 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 Inserting a new row
inserted above the selected row and the existing rows shift downwards.
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 the Insert command in the
cells group under the Home tab.
Step 3 Click on the Insert Sheet Columns.
A new column is inserted to the left
of the selected cells and the existing Inserting a new column
columns shift rightwards.
MERGING CELLS
To merge cells, follow these steps:
Step 1 Select two or more adjacent cells
that you want to merge.
Step 2 Click on Merge & Center command
Merging cells
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.
Merged Cells
Split Cells
Step 1 Select the merged cell you want to split.
Editing in MS Excel 31

