Page 27 - TP_Plus_v4_Class6
P. 27

Automatically Fit Column/Row Content

                 You can adjust the row height and column width according to the height and width of the contents in
                 the cell. To fit column/row content automatically, follow these steps:

                                                                   Double-click on any boundary between   2
                                   Click on the Select             two column/row headings.
                               1
                                   All button.







                     INSERTING ROWS/COLUMNS


                 Suppose you want to add more data between two rows or columns, then you might need to shift the
                 data by copy and paste method to create space between rows/columns. But this process is not suitable
                 when you have large data. So you can insert rows/column to overcome this problem.

                 To insert a row/column in a worksheet, follow these steps:


                         2  Click on Home tab.                             3   Click on Insert command.





                        Click  the   row
                        heading/column
                        heading   where
                    1   you  want  to add
                        a row/column



                                           4   Select the Insert Sheet Rows /Insert Sheet Columns option.


                     MERGING CELLS


                 While working on Excel you might need to combine some cells to show a part of data under one heading.
                 Combining two or more cells is known as merging. To merge cells, follow these steps:

                                                                                   Click  on  Merge  &
                                                   Click on Home tab.   2          Center command.      3








                       Select  two  or  more
                   1   adjacent cells that
                       you want to merge.







                                                                                                #More on Excel 2019  25
   22   23   24   25   26   27   28   29   30   31   32