Page 63 - iPro_trackGPT_V5_Class7
P. 63

Entire Worksheet: Click on the Select All button located below the Name box to select the
                    entire worksheet. The shortcut key to select the entire worksheet is Ctrl + A.

                 Modifying Cell Content

                 Excel offers two methods for modifying a cell's content: you can either edit the content in Edit
                 mode or overwrite the entire cell's content directly.
                 I.  To activate the Edit mode and change the content of a cell, follow the given steps:


                   1  Create
                   a new
                   workbook
                   and enter
                   some data
                   into the
                   worksheet.

                         Edit
                        mode                                                         3  Edit the content and
                        active                                                       press the Enter key.

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


                 II.  To replace the entire content of a cell, follow the given steps:




















                      1  Click on the cell whose                    2  Type new content
                      content you want to replace.                  and press the Enter key


                 You will notice that the old content is completely replaced with the new content.
                    COPYING/MOVING DATA


                 Similar to Word, data can be copied/moved from one cell to another in Excel. Let us perform
                 these operations.
                 Cut, Copy, and Paste Data

                 In Excel, you can use the Cut, Copy, and Paste commands to move or copy cell content. The Cut
                 command moves the content to a new location and removes it from the original spot. The Copy
                 command duplicates the content, leaving the original in place. The Paste command is used to
                 insert the copied or cut data to the new location.




                                                                                         More on Spreadsheets    61
   58   59   60   61   62   63   64   65   66   67   68