which tab has comments for data formatting
Answers
Answer:
You can either go to the Comments section on the REVIEW tab and click on the Edit Comment option or press Shift + F2. Highlight the text where you want to change the font. Right-click on the selection and choose the Format Comment option. The Format Comment dialog window will appear on your screen.
Answer:
Add comments in Excel
First I should say that the ways of inserting text and picture notes are different. So let's begin with the easiest of two and add a text comment to a cell.
Select the cell that you want to comment on.
Go to the REVIEWtab and click on the New Comment icon in the Comments section.
Click on New Comment in the Comments group on the REVIEW tab to insert a comment in Excel
Note. To perform this task you can also use the Shift + F2 keyboard shortcut or right-click on the cell and choose the Insert Comment option from the menu list.
By default, every new comment is labelled with the Microsoft Office user name, but this may not be you. In this case you can delete the default name from the comment box and enter your own one. You can replace it with any other text as well.
Note. If you want your name to always appear in all your comments, follow the link to one of our previous blog posts and find out how to change the default author name in Excel.
Enter your remarks in the comment box.
Type the text in the comment box
Click on any other cell in the worksheet.
The text will go, but the little red indicator will remain in the upper-right corner of the cell. It shows that the cell contains the comment. Just hover the pointer over the cell to read the note.
Explanation: