Page 50 - TechPluse_C6_Flipbook
P. 50
The default column width is 2.26 cm and the default row height is 0.45
cm. 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
Perform the following steps to set column width/row height:
Step 1 Select the column(s) or row(s) that you want to change.
Format menu
Step 2 Click on the Format menu.
Step 3 Hover mouse pointer over the Columns or Rows option. A
submenu appears.
Step 4 Select the Height or Width option.
Step 5 A Column Width or Row Height dialog box will appear.
Step 6 In the Column Width or Row Height box, type the value that
you want your column or row to be.
OR
Click on + icon to increase or – icon to decrease the column width or row height.
Row Height dialog box Column Width dialog box
Automatically Fit Column/Row Contents
Perform the following steps to automatically fit column/row contents:
Select All box
Step 1 Click on the Select All box.
Step 2 Double-click any boundary between two column/row
headings. All columns/rows in the entire worksheet will
Selecting entire worksheet
be changed according the contents of the cell.
Clickipedia
At times, a cell might display . This can occur when the cell contains data 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.
48 Premium Edition-VI

