Page 33 - TP_Prime_v2.2_Class_6
P. 33
Step 3: Choose Column Width or Row Height under the Cell Size section from the
drop-down list.
A Column width or Row height dialog box will appear.
Step 4: Type the desired value in the Column Width or Row Height box.
Column Width Dialog Box Row Height Dialog Box MORE ON EXCEL
Automatically Fit Column/Row Content
To automatically fill a column or content of a cell, follow these steps:
Step 1: Click on the Select All button. Select All button 31
Step 2: Double-click any boundary between two
column/row headings.
Step 3: All columns/rows in the entire worksheet will be
changed to the new size. Selecting Entire Worksheet
At times, a cell might display #####. This can occur when the cell
Fun
Fact! 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
We can add rows or columns in our worksheet wherever we needs.
Inserting Rows
To insert a row in a worksheet, follow these steps:
Step 1: Click on the row heading above which you want to insert a new row.
Step 2: Click on the Insert command under the Cells group on the Home tab.
Step 3: Select the Insert Sheet Rows option from the drop-down list.

