Page 37 - TP_Modular_V2.1_Class7
P. 37
Step 3 Choose Column Width or Row Height
under Cell Size section from the
drop-down list.
A Column width or Row height dialog
box will appear.
Step 4 In the Column Width or Row Height
box, type the value that you want your Setting column width
column or row to be.
Step 5 Click on OK button to get new row height / column width.
Row Height dialog box Column Width dialog box
Select All button
Automatically Fit Column/Row Content
To set column width or row height automatically, click on the Select All
button. Double-click any boundary between two column/row headings.
All columns/rows in the entire worksheet will be changed to the new
Selecting entire work-
size.
sheet
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.
Editing in Excel 2016 35

