Sprint Nextel 800w Formatting or Changing a Chart, Finding or Replacing Information in a Workbook

8.Select whether you want the chart to appear as a separate worksheet within the current workbook, or as part of the current worksheet.

9.Press Finish (right softkey).

Formatting or Changing a Chart

1.Open the workbook that contains the chart you want to format.

2.Open the chart.

3.Press Menu (right softkey) and select Format > Chart.

4.Select any of the following:

■Titles: Set the title of the chart and the headings, whether a legend appears, and the placement of the legend.

■Scale: Set the minimum and maximum scales for charts with an x or y axis.

■Type: Set the chart style. You can use this setting to convert your chart to a different format.

■Series: Add, modify, format, or delete related data points without affecting the information in your worksheet.

5.Press OK .

Finding or Replacing Information in a Workbook

1.Open the workbook containing the information you want to find.

2.Press Menu (right softkey) and select Edit > Find/Replace.

3.Select Find what and enter the information you want to find.

4.(Optional) Check the Match case box to find text that matches the capitalization in any text you entered.

5.(Optional) Check the Match entire cells box to find only full words that match any text you entered.

6.Select Find to locate the first instance of the information you entered, or select Replace and enter the replacement information.

282 Section 5B: Increasing Your Productivity