Page 43 - 2502_Pakistan-kifayat_C-8
P. 43

Selecting and Editing Cells

                 Apart from entering data into a worksheet, Excel also provides the facility to perform various other
                 operations with data such as modifying, inserting, moving/copying and deleting. To perform all these

                 operations, we first need to select the cell that contains data. Excel allows us to select a single cell or a
                 group of cells.

                    To select a Single Cell: Click on the cell to select it.
                     To select a Group of Cells or Range: Click on the first cell

                   from where you want to start the selection and drag the
                   mouse diagonally to the cell to which you want to make
                   selection.

                     We can also select a range of cells by using the Shift key. Click on the first cell and then press and
                   hold the Shift key and click on the last cell up to which we want to make a selection.

                     Entire Row/Column: Click on the row heading to select the entire
                   row or click on the column heading to select the entire column.                       Hintbot
                     Entire Worksheet: Click on the Select All button located below           Shortcut to select entire

                   the Name box to select the entire worksheet.                                 worksheet: Ctrl + A

                 Modifying Cell Content
                 To modify the cell content in a worksheet, follow these steps:


                           1   Enter  the  data
                               into worksheet.



                       Double-click  on  the  cell
                   2   whose content you want
                       to change.










                       After making  all the

                   3   changes, press the Enter
                       key from the keyboard.

                 Formatting Cells and Text

                 Formatting cells and text in Excel helps make your data easier to read and more visually appealing. You
                 can change the font style, size, and colour of the text. Additionally, you can align the text to the left,
                 centre, or right in the cell.






                                                                                                   #Microsoft Excel  41
   38   39   40   41   42   43   44   45   46   47   48