How to format comment boxes on excel spreadsheets.__After creating them and saving the spreadsheet, they disappear.____

Question

How do I make sure the comment boxes stays the same size after saving the spreadsheet.

Answer 1

When you hover the cursor on the cell which has comments are you able to view the comment?

Does the comment box size change after saving the excel spreadsheet?

Refer the link below for help on formatting the comment:

http://office.microsoft.com/en-us/excel-help/format-a-comment-HP005198897.aspx

"Does the comment box size change after saving the excel spreadsheet?"  YES! This is my problem. How do I fix? I either end up with boxes too small or so large they run off the screen. It doesn't matter how many times I readjust them they always end up changing in size again. It's very frustrating.

Answer 2

Are you also asking how to format a comment or you just wanted to know if some formatting option controlled the comment size?

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 3

When you hover the cursor on the cell which has comments are you able to view the comment?

Does the comment box size change after saving the excel spreadsheet?

Refer the link below for help on formatting the comment:

http://office.microsoft.com/en-us/excel-help/format-a-comment-HP005198897.aspx

Answer 4

Comment boxes stay the same size you set them to, but they may not stay in the same location.  If you want to insure the location you must leave the comment box displayed.

Saving the spreadsheet does not effect the comment's size

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 5

Hi,

Not sure If I understood you, when entering a comment you click on show comment and then you save the spreadsheet, when opening again the comments will be there