Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 61 - logicode 2609 C5
P. 61

    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  59

| 56 57 58 59 60 61 62 63 64 65 66 |