Editing Worksheet Data:
Some times the existing data in cells may require someEditing. Such as moving data from one location to other, clearing cell contents, and so on. Editing a Cell: You can edit the contents of the cell by using the formula bar or the in-cell editing option as described below:
Formula Bar Method:
In this method you need to:
1. Select the cell you want to edit.
2. Click on the formula bar or press the F2 function key.
The contents of the cell get displayed in the formula bar, which can be edited accordingly.
In-Cell Editing:
To edit the contents of a cell:
1. Double Click on the cell.
The insertion point appears at the end of the cell which can be moved to the required position for editing.

Clearing a Cell: To clear a cell is to erase the cell content but it is not similar to deleting a cell. There are two ways of clearing cell contents:
# Using the shortcut menu
1. Highlight the cell or range of cells to be cleared.
2. Click on the right mouse button.
3. Select the clear contents from the shortcut menu.

# Using the delete key: Select the cell and press delete key.
Copying Data: To create multiple copies of worksheet data, you can use the copy and paste method.
#Using menu bar
1. Select the cell or range of cells having the cell contents that are to be copied.
2. Select the copy option from the edit menu.
3. Select the cells in which you want to paste a copy of the data (you can paste it several times until you copy another).
4. Select the paste option from the edit menu or press ctl+v from keyboard.

#Using the shortcut menu
1. Select the range of data that you want to copy.
2. Click on the right mouse button.
3. Select copy from the shortcut menu.
4. Select the cells in which you want to paste your data.
5. Click on the right mouse button again and select the
Paste option from the shortcut menu.

#Using the auto fill
1. Select the cell or range of cells that contains the data you want to copy.
2. Position the mouse pointer on the fill handle.
3. Drag the fill handle over the adjacent cells.
4. Release the mouse button.

Cut and Paste Method: When you select the cut command to move any data, a copy of data is stored in the windows clipboard. Later when you use paste option, the data is placed in another area of the worksheet.
# Using the menu bar
1. Select the range of data.
2. Select the cut option from the edit menu.
3. Select the cells in which you want the data to appear.
4. Select the paste option from the edit menu.

# Using the shortcut menu
1. Select the range of data you want to move
2. Click on right mouse button and select cut option from
The shortcut menu shown as following.

Cut option of the shortcut menu

3. Select the cells in which you want the data to be placed.
4. Click on right mouse button and select paste option
From the shortcut menu.