Annotate a worksheet by using comments

Annotate a worksheet by using comments You can add notes to a worksheet by using comments. Using comments can h...

Annotate a worksheet by using comments

You can add notes to a worksheet by using comments. Using comments can help you make a worksheet easier to understand by providing additional context for the data it contains. For example, you can use a comment as a note that provides information about data in an individual cell, or you can add a comment to a column heading to provide guidance on data that a user should enter.

    Annotate a worksheet by using comments     Annotate a worksheet by using comments                    When a cell has a comment, a red indicator appears in the corner of the cell. When you rest the pointer on the cell, the comment appears.

After you add comments, you can edit and format the text in comments, move or resize the comments, copy them, display or hide them, or control how they and their indicators are displayed. When you no longer need comments, you can delete them.

What do you want to do?

Add a comment

Edit a comment

Format a comment

Move or resize a comment

Copy comments to other cells

Display or hide comments and their indicators

Change the default name that is displayed in new comments

Review all comments in a workbook

Delete a comment

Add a comment

  1. Select the cell that you want to add a comment to.

  2. On the Review tab, in the Comments group, click New Comment.

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Keyboard shortcut  You can also press SHIFT+F2.

    A new comment is created, and the pointer moves to the comment. An indicator appears in the corner of the cell.

    By default, the new comment is labeled with a name. To use a different name, you can select the name in the comment, and then type a new name. Or, you can remove the name by pressing DELETE.

    To change the default name that is used for comment labels, see the section Change the default name that is displayed in new comments, later in this article.

  3. In the body of the comment, type the comment text.

  4. Click outside the comment box.

    The comment box disappears, but the comment indicator remains. To keep the comment visible, do the following:

    1. Select the cell.

    2. In the Comments group on the Review tab, click Show/Hide Comment.

      You can also right-click the cell that contains the comment, and then click Show/Hide Comments.

      Notes: 

      • By default, text in comments uses the font Tahoma in font size 8. You cannot change the default font that is used, but you can change the format of the comment text in each comment by right-clicking selected comment text, and then clicking Format Comment. For more information, see the section Format a comment, later in this article.

      • When you sort data in a worksheet, comments are sorted together with the data. However, in PivotTable reports, comments do not move with the cell when you change the layout of the report.

Top of Page

Edit a comment

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

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

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Keyboard shortcut  You can also press SHIFT+F2.

    Note: If the cell that you select does not have a comment, the Edit Comment command is not available in the Comments group. Instead, the New Comment command is available.

  3. Double-click the text in the comment, and then in the comment text box, edit the comment text.

Top of Page

Format a comment

By default, text in comments uses the font Tahoma in font size 8. You cannot change the default font that is used, but you can change the format of the comment text in each comment. You can also change the shape of a comment; for example, you can use an oval callout instead of a rectangular comment. For more information, see Change the shape of a comment, later in this article.

Format comment text

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

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

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Keyboard shortcut  You can also press SHIFT+F2.

    Note: If the cell that you select does not have a comment, the Edit Comment command is not available in the Comments group. Instead, the New Comment command is available.

  3. Select the comment text that you want to format, and then do one of the following:

    • Right-click the selection, click Format Comment and then, in the Format Comment dialog box, select the formatting options that you want.

    • On the Home tab, in the Font group, click the formatting options that you want.

          Annotate a worksheet by using comments     Annotate a worksheet by using comments

      Note: The Fill Color and Font Color options in the Font group are not available for comment text. To change the color of the text, you can right-click the selected comment text, and then click Format Comment.

Change the shape of a comment

  1. Click the Microsoft Office Button     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    , and then click Excel Options.

  2. Click the Customize category.

  3. In the Choose commands from box, click All Commands.

  4. In the list box, select Edit Shape, click Add, and then click OK.

This adds the Edit Shape button to the Quick Access Toolbar.

    Annotate a worksheet by using comments     Annotate a worksheet by using comments

  1. In the worksheet, select the cell that contains the comment for which you want to change the shape.

  2. To display the comment on the worksheet, on the Review tab, in the Comments group, click Show/Hide Comment.

    Annotate a worksheet by using comments     Annotate a worksheet by using comments

  1. Click the border of the comment.

  2. On the Quick Access Toolbar, click Edit Shape, and then click Change Shape.

  3. Click the shape that you want to use.

Top of Page

Move or resize a comment

  1. Right-click the cell that has the comment that you want to change, and then click Show/Hide Comments.

  2. Click the comment box border so that sizing handles appear. Make sure that the pointer is not in the comment.

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

  3. Do one of the following:

    • To move the comment, drag the border of the comment box, or press an arrow key.

    • To resize the comment, drag the handles on the sides and corners of the comment box.

Top of Page

Copy comments to other cells

  1. Select the cell or cells that contain the comments that you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    .

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Keyboard shortcut  You can also press CTRL+C.

  3. Select the upper-left cell of the paste area.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    , and then click Paste Special.

    Keyboard shortcut  You can also press CTRL+ALT+V.

  5. In the Paste Special dialog box, under Paste, click Comments, and then click OK.

  6. To cancel the moving border, click another cell or press ESC.

    Note: Do not press ENTER after you click OK. If you do, cell contents will be copied to the paste area in addition to the comment.

Copied comments replace any existing comments in the destination area.

Top of Page

Display or hide comments and their indicators

By default, Excel displays an indicator only when a cell contains a comment, but you can control how Excel displays comments and indicators in cells by changing the default settings. You can also display or hide comments on the worksheet.

    Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Annotate a worksheet by using comments     Annotate a worksheet by using comments                    Indicator

    Annotate a worksheet by using comments     Annotate a worksheet by using comments                    Comment

Change the default display settings for comments

  1. Click the Microsoft Office Button     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    , and then click Excel Options.

  2. In the Advanced category, under Display, do one of the following:

    • To hide both comments and indicators throughout the workbook, under For cells with comments, show, click No comments or indicators.

    • To show indicators but display comments only when you rest the pointer over their cells, under For cells with comments, show, click Indicators only, and comments on hover.

    • To display both comments and indicators at all times, under For cells with comments, show, click Comments and indicators.

Display or hide comments on the worksheet

  1. Click the cell or cells that contain a comment indicator.

  2. On the Review tab, in the Comments group, click Show/Hide Comment.

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    You can also right-click the cell that contains the comment, and then click Show/Hide Comments.

Display or hide all comments on the worksheet

  • On the Review tab, in the Comments group, click Show All Comments.

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

    Clicking Show All Comments again will hide all comments on the worksheet.

Top of Page

Change the default name that is displayed in new comments

Excel labels each new comment by using a name that you specify in the Excel Options dialog box. You can change that name as needed.

  1. Click the Microsoft Office Button     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    , and then click Excel Options.

  2. In the Popular category, under Personalize your copy of Microsoft Office, type a name in the User name box.

    If the User name box is empty, when you add a comment, Excel automatically sets the value of the User name box to your user name, and uses that name for the label.

Although you cannot suppress comment labels, you can remove labels from comments by deleting them.

Top of Page

Review all comments in a workbook

  1. On the worksheet, click the first cell that contains a comment that you want to review.

  2. To review each comment, on the Review tab, in the Comments group, click Next     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    or Previous     Annotate a worksheet by using comments     Annotate a worksheet by using comments                    to view comments in sequence or reverse order.

        Annotate a worksheet by using comments     Annotate a worksheet by using comments

Top of Page

Delete a comment

  1. Click the cell that contains the comment that 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 Comment to display the comment, double-click the comment text box, and then press DELETE.

          Annotate a worksheet by using comments     Annotate a worksheet by using comments

Top of Page

Disclaimer : All images and content that you find here are believed to be in the "public domain". We do not intend to violate legitimate intellectual property, artistic rights or copyright. If you are the legitimate owner of one of the images and content posted on this site, and do not want to be displayed or if you need an appropriate credit, please contact us and we will immediately do whatever is needed by deleting or giving credit to the content displayed.

COMMENTS

Name

Google Aррѕ,1,lainnya,7522,Microsoft Access,1,Microsoft Excel,59,Microsoft Office,13,Microsoft Office 2003,4,Microsoft Office 2007,1,Microsoft Outlook,1,Microsoft Word,71,Mісrоѕоft Office Training,1,Mісrоѕоft Offісе 365,2,Office 2007,3,Power Map,1,PowerPoint,14,Windows Accessibility Options,1,
ltr
item
Microsoft Office Online: Annotate a worksheet by using comments
Annotate a worksheet by using comments
https://support.content.office.net/en-us/media/2f3266e0-f7e9-4a27-a311-2fd03410be23.gif
Microsoft Office Online
https://promisestoread.blogspot.com/2018/12/annotate-worksheet-by-using-comments.html
https://promisestoread.blogspot.com/
https://promisestoread.blogspot.com/
https://promisestoread.blogspot.com/2018/12/annotate-worksheet-by-using-comments.html
true
593202333244584315
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy