Once editing is activated, enter the text you want to add or review the existing comment to make changes to it. Open the Review Tab and click the Edit Comment command under the commenting tools.Right-click on the cell where you want to edit and choose Edit Comment in the dropdown list that appears.To edit a comment, you can do either of the following: How to Edit or Delete a CommentĪfter adding comments to your Excel workbook, you may want to make changes to the added comments. Then, click and drag one of the handles to resize the comment box to your preferred size. If you want to resize a comment box, move the mouse pointer to one of the sizing handles on the corners or sides until it turns into a plus sign with arrows. Before dragging the box, you must confirm that sizing handles are visible on all corners of the comment box. Then, select the specific comment box you want to move, and then click and drag the box to your preferred location. Next, move the mouse pointer over the border of the comment box until the pointer changes to a cross cursor with arrows. To move a comment to another cell, click the Show All Comments option under the Review tab so that the comments display without hovering over the cells. Resizing and moving comments is important when some comments are blocking other cells or comments in the adjacent cells. How to Move or Resize a CommentĮxcel also allows users to resize the comment box or move the comments to another cell in a worksheet. Excel does not include a function that allows users to show comments on only one worksheet in a workbook. Clicking the Show all Comments option makes the comments permanently visible until the option is turned off. Use the previous/next buttons to preview the comments one by one. The Show All Comments option shows all the comments on all worksheets in the workbook, and the workbooks you create while the option is active. To hide all the comments, click Show All Comments again to undo the previous action. If you want to show all the comments in the workbook, click the Review tab and then the Show All Comments button.Alternatively, click the review tab to open the commenting tools and click the show/hide comments. Right-click somewhere on the cell and select either show or hide the comment.If you want to hide or show the comment in each cell, do the following: To view the comment, hover your mouse pointer over the cell with a small red triangle.īy default, Excel is designed to keep the comments hidden, and each comment can be viewed by hovering over the cell with the comment.The triangle makes it easy to locate the cell with a comment. An inverted small red triangle will appear at the right corner of the cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |