Finding and Replacing and Adding Comments Text or Numbers

►Finding Text or Numbers  

 1-  On theEdit menu, click Find. The Find and Replace dialog box appears. Click the Optins button to display more Find options.

2-  In the Find what box, enter the text or numbers you want to search for. You can enhance your search as per the displayed options: Within, Match case, …

3-  Click Find Next.

                                     4-  To stop your search, press Close.

►Replacing Text or Numbers

1- Select the range of cells you want to search. If you want to search the entire worksheet, click any cell in the worksheet

2-  On the Edit menu, click Replace. The Find and Replace dialog box appears .Click the Options button to display more Replace options.

 

 3-In the Find what box, enter the text or numbers you want to search for or choose a    recent search from the Find what drop down box.  

Note: You can use wildcard characters in your search criteria. 

4- If you want to specify a format for your search, click      Format and make your  selections in the Find Format dialog box.

If Format is not available in the Find and Replace dialog box, click Options and then click Format.

5- Click Options to further define your search. For example, you can search for all of the cells that contain the same kind of data, such as formulas. 

In the Within box, you can select Sheet or Workbook to search a worksheet or an entire workbook. 

6- In the Replace with box, enter the replacement characters and specific formats if

necessary. 

If you want to delete the characters in the Find what box, leave the Replace with            box blank. 

7- Click Find Next. 

8- To replace the highlighted occurrence or all occurrences of the found characters, click Replace or Replace All. 

9- To cancel a search in progress, press ESC. 

Comments

►Adding Comments

You can attach notes to cells by using   comments. You can view each comment when you rest the pointer over the cell. To add a comment to a cell, go by the following procedure:

1-  Click the cell to which you want to

2- On the Insert menu, click Comment

3--  In the box, type the comment text.

4-  When you finish typing the text, click outside the comment box.

►Editing Comments

1-  Click the cell with the comment you want to edit.

2-  On the Insert menu, click Edit Comment.

  

►Clearing Comments

1-  Select the cell from which you want to clear comments.

2-  On the Edit menu, point to Clear, and then click Comments.

 

►Checking the Spelling

In addition to the traditional spell-checking features, Excel got new enhancements that add to your efficiency, the most important of which, is asking Excel to automatically check spelling as you type.

1- After you are done typing your data, click the Spelling button       on the Standard

toolbar.

OR form the main menu, select   Tools     →   Spelling.  If errors are  found, the

following Spelling dialog box appears.

 

2-For each word that is displayed in the Not in Dictionary box, select one of the following options (if available): 

To	Choose
ccept the current selection in the Suggestions box, or edit the text in the box and then click Change. When the selected error is a repeated word, this button changes to Delete so you can	Change
Change all instances of the word in the Not in dictionary to theword in the Suggestions box, or edit the text in the box and  then    click Change All. Excel changes all instances of the error	Change All
Adds the highlighted word in the Not in dictionary box to the custom dictionary. You will not be prompted to correct this word in the future	Add to Dictionary
Leaves the highlighted error unchanged and finds the next misspelling                                                           error.This button changes to Resume if you click in the document to             edit the worksheet. Click Resume to continue checking the spelling.	Ignore Once
Leaves all instances of the highlighted error unchanged throughout the document and continue to check the worksheet Excel will ignore this spelling error throughout the rest of the current Excel session.	Ignore All