Page 69 - iPrime_V2.2_class7
P. 69
Automatically Fit Column/Row Content
Select All button
Step 1 Click on the Select All button.
Step 2 Double-click any boundary between two column/
row headings. All columns/rows in the entire
worksheet will be changed to the new size.
Selecting entire worksheet
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
Inserting Rows
To insert a row in a worksheet, follow these
steps:
Step 1 Select the row heading where you
want to insert a new row.
Step 2 Click on the Insert command in the
Cells group under the Home tab.
Step 3 Select the Insert Sheet Rows option
Inserting a new row
from the drop-down list.
A new row is inserted above the selected row and the existing rows shift downwards.
New row inserted
Inserting Columns
To insert a column in a worksheet, follow
these steps:
Step 1 Select 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 Select the Insert Sheet Columns
option from the drop-down list. Inserting a new column
More on Spreadsheets 67

