Microsoft Excel Whiz 2002 2003

Lesson 2: Modifying Worksheets

Color-coded Worksheet Tabs

Coloring worksheet tabs helps you organize your work by adding color to your worksheet tabs.

To add color to sheet tabs, do the following:

1. Select the sheet you want to color.

2. Do one of the following:

   • On the Format menu, point to Sheet and the click Tab Color.

   • Right-click on the sheet tab, and then choose Tab Color.

     The Format Tab Color appears.

3. Click the desired color, and then choose OK.

Control Automatic Change with Smart Tags

Smart Tags allows you to immediately adjust how information is pasted or how automatic changes occur in your Office programs.

These are buttons that appear automatically on your worksheet which help you with tasks such as automatic correction options, paste options, automatic fill options, insert options, and formula error checking.

By clicking a button, you can choose from options related to your task without leaving the worksheet or the cells you are working on.

• Paste Options button - It appears just below your pasted selection after you paste text or data. When you click the button, a list appears that lets you determine how the information is pasted into your worksheet.

  The available options depends on the type of content you are pasting, the program you are pasting from, and the format of the text where you are pasting.

• Trace Error button - It appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left of the cell. When you click the arrow next to Trace Error, a list appears to give you options for error checking.

• Insert Options button - It appears next to your inserted cells, rows, or columns. When you click the arrow next to Insert Options, a list of formatting options appears.

• Auto Fill Options button - It appears just below your filled selection after you fill text or data in a worksheet. When you click the button, a list appears to give you options for how to fill the text or data.

  The available options depends on the content you fill, the program you fill from, and the format of the text or data you are filling.

Change Zoom Setting

To increase the view of a worksheet so the text is larger or to reduce its size to see more cells, you can use the zoom feature.

There are two ways to change the zoom setting of your worksheet:

1. Using the Standard toolbar in the click the size you want, or enter a number from 10 to 400.

2. Using the menu bar:

   1. in the View menu, click Zoom. The Zoom dialog box appears.

   2. In the Zoom dialog box, click a percent option, choose Fit Selection, or type a value in the Custom box.

   3. Click OK.

      To return the zoom to its original size, click 100% in the Zoom box on the Standard toolbar.

Check Spelling

Make sure that all words are spelled correctly. Misspelled words can distract the reader and damage your credibility.

To check the spelling in your worksheet, follow these steps:

1. Press Ctrl+Home to start the spell check at the beginning of the worksheet.

2. Do one of the following:

   • Press F7.

   • Click Spelling on the Standard toolbar.

   • Click the Tools menu, and then choose Spelling.

3. If there are any misspelled words, the Spelling dialog box is displayed.

   The misspelled word appears in the Not in Dictionary text box.

4. Do any of the following to correct the word:

   • Click Change to change the misspelled word with the selected suggestion.

   • Click Change All to change the misspelled word with the selected suggestion in the entire worksheet.

5. Do any of the following to manage the word displayed in the Not in Dictionary text box.

   • Click Ignore Once to skip the current occurrence of the word or Ignore All to skip all occurrences of the word in the worksheet.

   • Click Add to Dictionary to include the word in the dictionary. The word will no longer be considered misspelled when you check spelling again for any workbook.

   • Click AutoCorrect to add the word as an AutoCorrect entry.

6. If you accidentally changed the wrong word, click Undo Last.

7. When finished, click Close.

If you reach the end of the worksheet, a prompt will appear asking you if you want to continue from the beginning of the worksheet. Click Yes to continue.

After completing the spelling check, you will be prompted that the spelling check is complete.

Whiz Words

Lesson Summary

Adding color to your worksheet tabs helps you organize your work. To add color to your tab, click the worksheet tab you want to color. Right-click, then click on Tab Color, when the Format Tab Color appears, select the desired color, then click OK.

Smart Tags allow you to adjust how information is pasted or how automatic changes occur in your Office programs.

The Zoom feature of Excel allows you to magnify or shrink the view of the worksheet. The easiest way to change the Zoom setting of your worksheet is to click on the Zoom box, then type a value (10-400).

Spell Check corrects spelling errors in your work.

Study Help

Directions: Answer the following:

1. What is a smart tag? When does it appear?

   ---

   ---

2. How to check the spelling in the worksheet?

   ---

   ---

3. What is the importance of putting colors to the worksheet tab?

   ---

   ---

4. Why do we have to change the zoom setting of our worksheet?

   ---

   ---

1. Open the file Freeze.xls

2. Rename Sheet 1 to Freeze.

3. Spell Check the worksheet. Correct all misspelled words.

4. Change the zoom setting to 200.

5. Click Save.