Inserting and Deleting Rows, Columns and Cell Range:
You can insert rows, Column, and Cell ranges, If required. To do so we can take the following step:
Inserting Column:
(Step For) Using the menu bar:
1. Position the cell pointer on the column where you want the new column should be inserted.
2. Select the column option from the insert menu. A column will be inserted.
Using the shortcut menu:
1.Position the cell pointer in the column where you want a new column should be inserted.
2. Click on the right mouse button on the column header and select the insert option from the shortcut menu.


Insert option from the shortcut menu.

Deleting a Column:
Using the main menu
1. Click the letter of the column you want to delete.
2. Select the delete option from the edit menu.

Using the Shortcut Menu
1. Select the letter of the column you want to delete.
2. Click on the right mouse button &select the delete option from the shortcut menu.
Inserting a Row:
Using the main menu
1. Select a cell in the row below the location where the new row should appear.
2. Select the row option from the insert menu.
Using the Shortcut Menu
1. Select a cell in the below where the new row should appear.
2. Click the right mouse button on the row header & then select insert option from the shortcut menu.

Deleting a row
Using the Menu Bar
1. Select the row, which you want to delete.
2. Select the Delete option from the Edit menu.
Using the Shortcut Menu
1. Select the row, which you want to delete.
2. Click the right mouse button & select the Delete option from the Shortcut menu.
Inserting a Cell or Cell Range
Using the Main Menu
1. Select the cell or cell range where the new cell should appear.
2. Select the Cells options from the Insert Menu.
3. Select Shift cell right or Shift cells down accordingly from the Insert dialog box.
Using the Shortcut Menu
1. Select the cell or cell range where the new cell should appear.
2. Click the right mouse button.
3. Select the insert option from the shortcut menu.
4. Select Shift cell right or Shift cells down accordingly from the Insert dialog box.
Deleting a Cell or Range
Using the Main Menu
1. Select the cell or cell range that you want to delete.
2. Select the Delete option from the Edit Menu
3. Select Shift cells right or shift cells down accordingly from the delete box.
Inserting Sheets:
Using the shortcut menu
1. Click the right mouse button on the sheet tab.
2. Select insert from the shortcut menu.


Insert option from shortcut menu

Deleting Sheets:
Using shortcut menu
1. Place the mouse pointer over the sheet tab which you want to delete.
2. Click the right mouse button and select delete option from the shortcut menu.

Finding Data:
1.Select the find option from the edit menu or press ctrl+F. a ialog box will appear on the screen, which is shown below:


Find dialog box

3. In find text box, type the data you want to find, then specify the search option.

Replacing Worksheet Data
1. To search the entire workbook, select a single cell.
2. If you are searching for a range, then select the range
You want to search.
3. Select the option from edit menu. A dialog box will
Appear on the screen as follows


Replace dialog box

4. In the find what text box, type the data which you want to replace current data.
5. In the replace with text box, type the data you want to replace with.

Spell Checking:
To spell check of your worksheet you can follow the
Step:
1. Specify the worksheet range that you want to spell check. To check the entire workbook, select cell A1.
2. Select the spelling option from the tools menu.
3. When an error is detected, the spelling dialog box is displayed as follows:


Spelling dialog box

4. You will find some option there choice the option you need.
5. Auto correct feature instantly correct commonly
Miss spelled words.