Page 71 - TP_Pro_V5.1_Class5
P. 71

We can select a range of cells with the help of:

                 Mouse: Left-click the mouse on one cell and drag it to the last cell.
                 Keyboard: Move the cursor on the first cell of the range by using the Arrow keys. Then,

                 press the Shift key, and while keeping it pressed, use the Arrow keys to select the range
                 of the cells.

                 Mouse + Keyboard: Left-click on the first cell of the range, then press the Shift key. Now,
                 move the cursor to the last cell of the range and left-click again.

                 By typing the cell range in the cell number box:

                 <Address of the 1st cell>:<Address of the last cell>
                 Example: Enter C5:E5 in the cell number box and then press the Enter Key.

                 We can deselect the range of the cells by clicking anywhere on the sheet.


                 SELECTING MULTIPLE CELLS

                 To select a group of cells that are not next to each other, click on the first cell. Now, keeping
                 the Ctrl key pressed click on the other cells to select. All the selected cells will be highlighted.


                 SELECTING AN ENTIRE WORKSHEET

                 To select the whole worksheet, click the Select All triangle. This button is present above
                 row 1.



                                   Click here to select
                                                                          Short key  Ctrl  +  A
                                   an entire Worksheet                        To select an entire
                                                                              worksheet:













                           EDITING CELL CONTENTS

                 After entering the data in the cells, we can edit the data entered in the worksheet.

                 Cell contents can be edited in two ways.


                 REPLACING THE TEXT
                 Replacing the content means overwriting the data. The current content will be replaced

                 by the new entry. For this, we need to select the cell that we want to edit and then type the
                 new text to replace the old one.



                                                                                               Editing in Excel 2021  69
   66   67   68   69   70   71   72   73   74   75   76