Page 54 - TP_Play_V2.1_class5
P. 54
COLUMN WIDTH AND ROW HEIGHT
On a worksheet, you can specify a column width of 0 to 255 and a row height of
0 to 409. This value represents the number of characters that can be displayed in
a cell that is formatted with the standard font. The default column width is 8.43
characters and the default row height is 15 points. If a column/row has a width or
height 0, it is hidden, i.e., it is not visible in the grid.
Set Column Width/Row Height
To set column width or row height, follow the given steps:
Step 1: Select the column(s) or row(s) whose width or height you want to change.
Step 2: Click on Format command in Cells group from Home tab.
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 column or row to be.
Step 5: Click on OK button to get new row height / column width.
2
3
1
Setting column width
5 4
Row Height dialog box Column Width dialog box
Automatically Fit Column/Row Content Select All button
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 Selecting entire
worksheet will be changed to the new size. worksheet
52 Play (Ver. 2.1)-V

