Skip to main content

TIP - 50 : Convert note to comment in excel


Convert note to comment in excel

In excel, we have two varieties of highlighting of information –

1)   Notes - Under notes we can update the cell with a “NOTE” about a particular text to be displayed.
2)   Comments – In comments, where we can update a particular text same like note, but there is additional advantage of tracking of the comments updated by the others with the time stamp (it looks like how a mail chain having replies)

Step 1: Please select a cell and enter a comment by clicking Notes from Review tab

Step 2: Then click on “Convert to comments”, so that the note now turns into a comment.

Very helpful when we have review comments. (Preparer and reviewer concept).

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more