Page 56 - TP-Play_V-2.0_Book-5
P. 56
Clickipedia
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 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.
2 3
1
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.
2
1
3
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.
56 Play (Ver. 2.0)-V

