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
   45   46   47   48   49   50   51   52   53   54   55