Page 55 - TP_Play_V2.1_class5
P. 55
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
What if you could use Excel to track the books you’ve read and the books
you want to read? How would you rate them and what genres would you
include?
Editing in Excel 2016 53

