Page 69 - ConceptGP_C5_Fb
P. 69

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 A 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 2010  67
   64   65   66   67   68   69   70   71   72   73   74