Commenting on shared documents

Comments in Excel are not new option. Nevertheless, from the version to the version, there was more and more work to improve the possibility of collaborative work on the documents. Consequently, Excel has a new type of comment. They refer to commenting on shared documents, which in most cases are on the OneDrive repository, and you can view them in a simple way: by clicking the Comments button in the upper right corner of the window.

Doodling over the document

Excel is increasingly being used on mobile devices. Although, due to their size, they are not the ideal solution for making reports, as they enable mobility, these computers or tablet devices are a great solution for the presentation of reports. Recently Excel got a group of options, integrated in the Draw ribbon, which allow you to doodle over report and leave comments, just like you would do with the pencil.

VBA and comments

Comments in Excel are a convenient way to leave notes about the results of the calculations you made or otherwise explain your work within the worksheet. VBA allows you to easily add and delete comments. The following text will describe how to create programs by which you add or delete comments from within an active cell.

Change of comment’s appearance

Comments are graphic objects and therefore we can change their appearance. Why should we do it? Perhaps to be original, that the reports we made look different from the others? In this case, we can change the form of comments. And then, we can change the style of the text in the comment or the color of its background. Let’s show you how to comment with certain comments on certain parts of the report!

Using comments

More people working together on one document is a common practice. Sometimes it is necessary to leave a comment for harmonization of work with other users or easier understanding of the data and procedures during the budget creation. The comment should be visible, include the name of the person who commented on content and can, if necessary, be easily removed from the screen or not printed along with the data in the tables. Welcome to the world of Excel comments!