Add or remove a comment

Comments are notes that you attach to cells, separate from other cell content. You can enter one comment per cell. A cell that contains a comment displays an indicator triangle in the upper-right corner of the cell. When you rest the pointer over the cell that displays an indicator triangle, the text of the comment appears in a box near the cell.

Example of a comment in a cell

Kommentar i celle

When you sort data, comments are sorted along with the data. In PivotTable reports, however, comments do not move with the data when you change the layout of the report. Comments in a PivotTable report remain anchored to the cells where you entered them, not to the data in that cell.

Do any of the following:

Add a comment

  1. Click the cell where you want to add a comment.

  2. On the Review tab, under Comments, click New.

    Fanen Gennemse i Excel, gruppen Kommentarer

  3. In the box, type the comment text.

    To remove your name from the comment, select your name and delete it.

  4. When you have finished typing the text, click outside the comment box.

Edit a comment

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

    Bemærk: If you can't see comments, or comment indicators, on the Review tab, under Comment, click Next to see each comment in the workbook.

  2. Click in the comment and make your changes.

  3. When you have finished, click outside the comment box.

Copy a comment

  1. Hold down CONTROL , click the cell that contains the comment, and then on the contextual menu, click Copy.

  2. Hold down CONTROL , click the cell where you want to paste the comment, and then on the contextual menu, click Paste Special.

  3. Click Comments.

  4. To cancel the moving border, press ESC .

    Bemærk: A comment that is copied to a cell replaces any existing comment in the destination cell.

Delete a comment

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

  2. Hold down CONTROL , click the cell that contains the comment, and then on the contextual menu, click Delete Comment.

Delete all comments on a sheet

  1. On the Edit menu, click Go To.

  2. Click Special.

  3. Click Comments, and then click OK.

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

Hide comments or their indicators

If you don't want comments or comment indicators to be displayed on a sheet, you can hide them.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click View   Knappen Vis indstillinger i Excel .

  3. Under For comments, show, select the option that you want.

Remove your name from comments

  1. On the Review tab, under Comments, click Next.

    Fanen Gennemse i Excel, gruppen Kommentarer

  2. Select your name on the comment and delete it.

  3. Continue clicking Next, removing your name from each comment until you reach the end of the workbook.

See also

Print comments

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×