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

