Page 55 - TP-Play_V-2.0_Book-5
P. 55
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.
2
1
3
Setting column width
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
Editing in Excel 2016 55

