Threaded Comments in Excel 2016 (Office 365) In Excel options, you can change whether to hide the indicators, or whether to show the Comments and indicators all the time.īecause of the flexible formatting capabilities of Comments, they can be helpful in documenting worksheets and guiding users performing their tasks. When you hover the mouse over one of the indicated cells, its Comment appears. You could set up a catalog or invoice that shows an item’s picture when you mouse over its name or description.Īnd like other shapes in a worksheet, you can change their shapes, like the star in the screenshot below.īy default, Comments are not visible, but the top right corners of cells containing Comments are marked with small red triangular indicators. You can even format their fills to contain pictures. And you can choose to show certain shapes even when the mouse isn’t hovering over their cells. You can resize Comments, and format their fonts, borders, and fills like any other shapes. This is the default size and appearance of a Comment. When you hover over a cell with a Comment, the comment appears, with an arrow pointing back to its parent cell.
If the cell you right-click on already has a Comment, you have some Comment-related items on the context menu (below right). You can also create a Comment using the context menu, when you right-click on a cell (below left). In the Comments group there are buttons to insert a new Comment, navigate among Comments, and show or hide Comments. In Excel 2013, you can access Comments through the Review tab of the ribbon (I will use Excel 2013 to show these old-school Comments, since my Excel 2016 has been updated through Office 365). Everything in this section that refers to Excel 2013 Comments is valid for Excel 2010 and earlier Comments and for Excel 2016 Notes. The best news about Threaded Comments is that they will not replace Notes Threaded Comments and Notes can coexist side-by-side in a worksheet. In later releases, the Legacy Comments are now referred to as Notes. I don’t care for that “Legacy” adjective, because it makes me fear that the item will disappear. When Threaded Comments first came out, Microsoft referred to the old-style comments as Legacy Comments.
Comments have become indispensable for documenting worksheets and helping users navigate through models and dashboards. In Excel 97, Notes were renamed as Comments, with the interface we are now so familiar with. Notes (“Legacy” Comments)Ĭomments were first introduced in Excel 5/95, when they were called Notes, and the interface to work with Notes was rather cumbersome. In this post I will give a summary of Notes in Excel (as the old-style comments have been renamed), then I’ll show a little bit about the new Threaded Comments, and talk about compatibility between them. The second comment, posted by one of my accounts (with the “JP” icon), shows a reply by another of my accounts (with my picture), and another reply by a third account (with the lone “J” icon).
Here we see two comments in the new Comments task pane. You can have multiple comments, and other people with access to the workbook can enter their own comments, or reply to yours. They are a lot like comments on a blog or forum, or on a web site like Facebook. Threaded comments allow for discussions within and Excel workbook. What are these new Threaded Comments? Doesn’t Excel already have comments? And of course, you won’t see them in Excel 2013 and earlier.
#Excel for mac show comments on hover license
If you have the perpetual license version of Office 2016, you don’t get the same feature enhancements as Office 365 subscribers. If you have Office 365, you may already have Threaded Comments, if you are on an accelerated “Insider” release schedule, or you may see it sometime soon. As part of Microsoft’s new philosophy of releasing new products when they are ready, rather than waiting for the next big release every three or four years, we now have Threaded Comments in Excel.
0 kommentar(er)
