Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2629_Devagiri_C-6
P. 35

    AUTOMATICALLY FIT COLUMN/ROW CONTENT
                     You can adjust the row height and column width automatically to fit the contents of the cells.

                     To resize columns/rows to fit the content, follow the given steps:

                                       2    Double-click on any boundary
                                     between two column or row headings.

                       1    Click on the
                      Select All button.

                     This will automatically resize all columns or rows in the worksheet to fit their contents.

                            INSERTING CELLS, ROWS AND COLUMNS

                     In Excel, you can easily insert new cells, rows or columns to organise your data and expand your
                     worksheet.

                     INSERTING BLANK CELLS

                     Excel allows you to insert one or more cells into a worksheet. To insert a cell, follow the given steps:

                                                                                                4    Choose either Shift cells
                                                  2    Click on the Insert down                 right or Shift cells down to
                                                   arrow in the Cells group.                       insert the blank cell.

                                                                      3    Select the Insert Cells
                                                                     option.

                                                               1    Select the cell where you
                                                               want to insert a blank cell.

                                                                                           5    Click on the OK button.

                     This will insert a blank cell and shift the surrounding
                     data accordingly.                                                            SHORT SIGN

                     INSERTING ROWS OR COLUMNS                                                  To insert row/column:
                                                                                                    Ctrl + Shift + +
                     You can insert a blank row or column anywhere in the worksheet.

                                                                                                                      33
                                                                                                         Explore Excel

| 30 31 32 33 34 35 36 37 38 39 40 |