Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 84 - 2612 Digimind C5
P. 84

    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.

                                         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.

                       82   Premium Edition-V

| 79 80 81 82 83 84 85 86 87 88 89 |