![]() If you want to display the comment for a single cell, select the cell and press the Show/Hide Comment button on the ribbon. This button acts as a toggle, so clicking the button again will hide all the sheet comments. If you have many comments on a sheet, and you don’t wish to select each cell individually to read all the comments, you can force the display of all comments by selecting Review (tab) -> Comments (group) -> Show Comments. You can also edit a comment by pressing Edit Comment (or right-clicking on a cell and selecting Edit Comment) as well a delete a comment by selecting Delete (or right-clicking on a cell and selecting Delete Comment.) Quickly show all Comments When dealing with a workbook that contains many comments, perhaps spread across great distances, the Next and Previous buttons in the Comments group allow for speedy navigation from one comment to another. If you would rather insert a comment via the ribbon, click Review (tab) -> Comments (group) -> New Comment. ![]() To insert a comment using a keyboard shortcut, select the appropriate cell and press Shift-F2.Īn easy way to remember this keyboard shortcut the F2 key edits the cells content, whereas Shift-F2 edits the cells comment. Worksheet cells with embedded comments are easy to recognize by their red triangle in the upper right of a cell. This post will be focusing on the original form of comments, now called Notes. The original comments feature in Excel has been retained, but due to such an extreme similarity of features (original Comments versus Threaded Comments), the original Comments are now referred to as Notes and the new Threaded Comments are referred to as Comments. This allows users to reply to other’s comments and keep better track of the conversation. At the time of this posting (February 2019) Microsoft introduced a new Excel feature called Threaded Comments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |