Edit or delete an annotation in Excel 2007

In Microsoft Office Excel 2007, you can add a comment to a cell by inserting an annotation. You can edit the text in the annotation, or you can delete the annotations that you no longer need.

Comments

　　Add annotations

1, click the cell that you want to add the annotation to.

2, on the Review tab, in the Comments group, click New Annotation.

New annotation

3, in the Annotation text box, type the annotation text.

Note in annotations, Excel automatically displays the name, which appears in the Name box under Global Office settings on the personalization category of the Excel Options dialog box (Microsoft Office button

, Excel Options button). If you want, you can edit the name in the Name box. If you don't want to use a name, select the name in the annotation, and then press Delete.

4. To format text, select the text, and then use the formatting options in the Font group on the Start tab.

Set font

Note the fill color and font color options in the Font group are not available for annotation text. To change the color of the text, right-click the annotation, and then click Format Annotation.

5. After you type the text and format it, click the worksheet area outside the annotation box.

Tip The red small triangle in the corner of the cell indicates that the cell is annotated. Comments are displayed when you place the pointer over a red triangle.

Comments

• To be able to see the annotation with the cell, you can select the cell that contains the annotation, and then click Show/Hide annotations in the comments group on the Review tab. To display all annotations on the worksheet with the cell that you are commenting on, click Show All Annotations.

• When sorting, annotations are sorted with the data. However, in PivotTable reports: An interactive, crosstab Excel report that summarizes and analyzes data from multiple sources, including external data for Excel, such as database records. , the annotation does not move with the cell when you change the layout of the pivot table.

　　Edit annotations

1, click the cell that contains the annotation you want to edit.

2. Do one of the following:

• On the Review tab, in the Comments group, click Edit Comment.

Note When you select a cell that contains comments, you can use edit annotations in the annotation group instead of new annotation.

• On the Review tab, in the Comments group, click Show/Hide annotations to display annotations, and then double-click the text in the annotation.

3, in the Annotation text box, edit the annotation text.

4. To format text, select the text, and then use the formatting options in the Font group on the Start tab.

Set font

Note the fill color and font color options in the Font group are not available for annotation text. To change the color of the text, right-click the annotation, and then click Format Annotation.

　　Delete annotations

1, click the cell that contains the annotation you want to delete.

2. Do one of the following:

• On the Review tab, in the Comments group, click Delete.

• On the Review tab, in the Comments group, click Show/Hide annotations to display annotations, double-click the annotation text box, and then press Delete.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join