Page 23 - TP_Pluse_V2.2_Class_6
P. 23

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 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 the 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 the Format command in the Cells group from the Home tab.
                 Step 3:   Choose Column Width or Row Height under the 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


                                          Column Width dialog box      Row Height dialog box
                      Automatically Fit Column/Row Content

                 To automatically fill a 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

                                                                                              More on Excel 2016   21
   18   19   20   21   22   23   24   25   26   27   28