Edit Comment Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Edit Comment Excel






Edit  a Comment in Excel

The Video above explains how to insert or Add Comments in MS Excel. The Text below is from a Microsoft Excel Support Blog

 

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.excel ribbon imageKeyboard 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.

 

 

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.excel ribbon imageKeyboard 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.Excel Ribbon Image

      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 File tab.
  2. Under Excel, click Options.
  3. Click the Quick Access Toolbar category.
  4. In the Choose commands from box, click All Commands.
  5. In the list box, select Edit Shape, click Add, and then click OK.This adds the Edit Shape button to the Quick Access Toolbar, which is located in the top left corner of the Excel window.Quick access toolbar
  6. In the worksheet, select the cell that contains the comment for which you want to change the shape.
  7. To display the comment on the worksheet, on the Review tab, in the Comments group, click Show/Hide Comment.excel ribbon image
  8. Click the border of the comment.
  9. On the Quick Access Toolbar, click Edit Shape, and then click Change Shape.
  10. Click the shape that you want to use.

 

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.Worksheet comment with sizing handles
  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.

 

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 Button image .The Clipboard group on the Home tabKeyboard 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 Button image , and then click Paste Special.

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

  1. In the Paste Special dialog box, under Paste, click Comments, and then click OK.
  2. 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.

NOTE: Copied comments replace any existing comments in the destination area.

 

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.

Comment box and its red triangle indicator

Button image Indicator

Callout 2 Comment

Change the default display settings for comments

  1. Click the File tab.
  2. Under Excel, click Options.
  3. 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.excel ribbon image

    TIP: 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.excel ribbon imageClicking Show All Comments again will hide all comments on the worksheet.

 

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 File tab.
  2. Under Excel, click Options.
  3. In the General 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.

 

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 Button image or Previous Button image to view comments in sequence or reverse order.excel ribbon image








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok