![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |