How to Change the Default Comment in MS Excel

1.
To change the username, select 'Tools' from the main menu (generally found across the top of the Excel worksheet). Select 'Options' from the drop-down menu that opens. A pop-up window opens; select the 'General' tab. In the box labeled 'User Name,' type in the desired name. This is the name to which all comments on this workbook will be attributed.
2.
Use the 'Format Comment' pop-up window to change the other parameters of the text box . Right-click on the cell that contains the comment. A drop-down menu opens; select 'Show/Hide Comment.' Place your cursor over the edge of the comment box and right-click. Select 'Format Comment' from the drop-down menu that opens.
3.
To change the comment text font, navigate to the 'Format Comment' pop-up window as described in Step 2. Select the 'Font' tab. Make desired changes to the font, font style, font size, font color and font effects. Click 'OK' to save the changes.
4.
To change the comment text alignment, navigate to the 'Format Comment' pop-up window. Select the 'Alignment' tab. Make the desired changes to the text alignment, the orientation of the text and the text direction. Click 'OK' to save the changes.
5.
To change the comment box lines and colors, select the 'Colors and Lines' tab in the 'Format Comment' pop-up window. Make desired changes to the fill (the color of the inside of the comment text box) and line (what type of border will be around the comment text box). Click 'OK.'
6.
To change the comment box size, select the 'Size' tab in the 'Format Comment' pop-up window. Make the desired changes to the height and width. Click 'OK' to save the changes.
7.
To change the protection of the comment box, select the 'Protection' tab in the 'Format Comment' pop-up window. Change the status of the comment from locked to unlocked, or from lock text to unlock text, by placing a check mark in the appropriate box. Click 'OK' to save the changes.
8.
To change the comment text box properties, select the 'Properties' tab in the 'Format Comment' pop-up window. You can use this tab to determine the positioning of the comment text box. 'Move with Cells' means that, if you copy and paste cells, the comment will be copied and pasted as well. 'Size with cells' means that, if you change the size of the cell (row height), the comment size will change as well. Click 'OK' to save the changes.
9.
To change the comment text box margins, select the 'Margins' tab in the 'Format Comment' pop-up window. Make the desired changes to the left, right, top and bottom margins of the comment text. This affects the comment and the user name to which the comment is attributed. Click 'OK' to save the changes.
10. To change the comment text box web functionality, select the 'Web' tab in the 'Format Comment' pop-up window. If you are linking this workbook and its comment to the web, you can insert alternative text that is viewable by users when the image of the workbook or comment is not available. Click 'OK' to save the changes.
11.