Microsoft Excel Whiz 2002 2003

Lesson 4: Adding Comments to Your Worksheet

Adding Comments

A comment is a note that you attach to a cell, separate from other cell content. Comments are useful as reminders or to provide feedback to other users.

To add comments to a cell, follow these steps:

  1. Select the cell where you want to insert a comment.

  2. Do any of the following:

    • From the Insert menu, click Comment.

    • Right-click on the selected cell and then choose Comment. The Comment text box appears prompting you to type your comment. It also displays the user name of the computer.

Once you inserted a comment, it will always be visible on your worksheet. To hide your comment so that it will only appear when you point to the cell that has a comment, click on View menu and then click Comment.

Viewing Comments

Microsoft Excel provides several ways to view comments. Cells with comments have indicator triangles in the upper-right corners. If you rest the pointer over a cell that has an indicator, its comment appears. You can also display comments continuously either individual comments or all the comments on the worksheet. The Reviewing toolbar steps you through each comment in a workbook in sequence. You can also print out the comments, either in place on the worksheet or as a list at the end of the printout.

Editing Comments

To edit comments, do the following:

  1. Select the cell that contains the comment you want to edit.

  2. On the Insert menu. Click Edit Comment.

  3. The Comment Text box appears and from there you can edit your comment.

You can also right-click on the cell and the click Edit Comment.

Deleting Comments

  1. Select the cell that contains the comment you want to remove.

  2. Do any of the following:

    • On the Edit menu, choose Clear and then click Comments.

    • Right-click and then click Delete Comment.

Creating and Responding to Discussion Comments

Discussion comments are remark or topic of discussion that is associated with a web page or MS Office files and stored on a discussion server.

Note

You can only use the Web Discussion feature if you have a discussion server.

Creating Discussion Comments

  1. On the Tools menu, point to Online Collaboration, and click Web Discussions.

  2. If the Add or Edit Discussion Servers dialog box appears, select a discussion server.

  3. On the Web Discussions toolbar, click Insert Discussion about the Document.

  4. Under Discussion subject, type a name for the subject of the discussion.

  5. Under Discussion text, type your comments.

  6. When you click OK, your comment appears in the Discussion pane at the bottom of the window.

Reply, Edit, and Delete Web Discussions

Web Discussion Toolbar

  1. At the end of the discussion comment, click Show a menu of actions and then click Reply, Edit, or Delete.

  2. If you are replying to or editing a comment, under Discussion text, type your reply or type any changes you want to make to the text.

Filtering List using AutoFilter

AutoFilter is used if your worksheet is setup like a database. AutoFilter enables you to select only items you want to see in a list.

To activate AutoFilter, do the following:

  1. Position the active cell indicator in the list.

  2. On the Data menu, choose Filter and then click AutoFilter.

Notice that each field name now has an arrow that you can use to select the data you want to see.

When the AutoFilter is activated, you can display the data you want by doing any of the following:

Choose the desired option from the drop-down list and then click OK.

Whiz Words

Comments

AutoFilter

Lesson Summary

Comments are notes that you enter for a cell. You can easily determine that a cell has a comment by the indicator triangles in its upper-right corner.

AutoFilter allows you to view a portion of your data in a worksheet if it is setup as a database.

Study Help

  1. Define comment.

  2. How can you determine that a cell has a comment?

  3. What is the use of AutoFilter?

Activity 1

  1. Create a new worksheet.

  2. Copy the illustration show below.

  3. Insert a comment to the State field. Choose only one per state. Write the following comments: AL-stands for Alabama, AK-stands for Arkansas, and AZ-stands for Arizona.

  4. Apply the 3-D Effects 2 format to your table.

  5. Apply AutoFilter to the table.

  6. Save you work as Sales Report in Excel-Activities folder.

Related

Категории