Page 24 - Plus_V2.2_C6_Flipbook
P. 24

Tech Hint

                                                                              To copy, cut and paste the content
                                                                              of the cells the shortcut keys used
                                                                              in Excel:

                                                                              • To Copy: Ctrl + C
                                                                              • To Cut: Ctrl + X

                                                                              • To Paste: Ctrl + V
                                   Pasting contents of a cell



                         COLUMN WIDTH AND ROW HEIGHT

                  On a worksheet, you can specify a column width of 0 to 255 and 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 of a cell, follow these 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.




                                                                                                   Setting column width


                                           Row Height dialog box       Column Width dialog box

                       Automatically Fit Column/Row Content
                  To automatically fill column or content of a cell, follow these steps:  Select All button
                  Step 1:  Click the Select All button.

                  Step 2:   Double-click any boundary between two column/row
                          headings.
                  Step 3:   All  columns/rows in the entire  worksheet  will  be
                          changed to the new size.                                         Selecting entire worksheet

                  22    Premium Edition-VI
   19   20   21   22   23   24   25   26   27   28   29