Page 259 - open office
P. 259

EDITING CONTENTS IN A WORKSHEET
                 After creating a worksheet, the user may require to edit the contents or data of a cell or a range of cells.
                 Editing refers to:

                   Modifying the contents/data                                      Deleting the contents/data

                   Copying the contents/data                                        Moving the contents/data
                   Inserting contents/data

                   Cancelling or repeating the recent actions
                 Modifying the Cell Content

                 Cell content can be modified by either replacing or deleting it.

                 To replace the cell content:

                   Select the cell whose contents have to be modified. Type the new content and press the  Enter  key. The
                   old data gets replaced with the new one.
                 To delete the cell content:

                   Select the cell or the range of cells and press the ‘Delete’ key.
                 Inserting Cells

                 To insert cells, follow the given steps:

                 Step 1:  Click on the area where the cell/cells have to be inserted.

                 Step 2:  Select the option ‘Cells’ from the ‘Insert’ menu. The ‘Insert Cells’ dialog box opens.
                 Step 3:  Select the desired option.
                 Step 4:  Click on the  OK  button to add a new cell in a worksheet.




                                             3                                             4







                    Sneak Peek


                          To insert a cell in MS Excel:

                          1.  Click on the Home tab.
                          2.  Click on the drop-down arrow of the Insert command. A drop-down list of options will open.
                          3.  Click on the Insert Cells option. The Insert dialog box appears on the screen.
                          4.  Click on the Shift cells right or Shift cells down radio button to shift the existing cells
                             towards  right or down respectively.
                          5.  Click on the OK button.








                                                                                     Working with Spreadsheet       25
   254   255   256   257   258   259   260   261   262   263   264