Enlarging comment box to show entire comment

mouchers

New Member
Joined
Sep 27, 2006
Messages
7
When I insert a comment into a cell and look at it afterwards it only shows a few lines of the text, if I need to put quite a bit of text into the comment I find that when I come to look at it later I cannot see most of my comment as the box of text is too small to show more than the first few lines.

How can I expand the 'comment box' to make my entire comment visible?

Thanks in advance.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
Right click on COmment box > Format Comment > Alignment > check Automatic size.

HTH
 

mouchers

New Member
Joined
Sep 27, 2006
Messages
7
I've attempted this by taking the following steps;
- I right clicked on the cell that has the comment attached to bring up 'edit comment'.
- I clicked on 'edit comment', which then allowed me to right click on the comment box.
- Once I had right clicked on comment box I selected 'format comment'.

At this point however I was not offered any 'alignment' tab, I was only offered a 'font' tab, in which there was no oportunity for me to select any 'alignment' or 'check automatic size' tabs or choices.

Could you please help any further? am I doing something wrong? thank you very much for your help.
 

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
See the picture.

FormatComment.jpg
 

Fergus

Well-known Member
Joined
Mar 10, 2004
Messages
1,174
When the comment box is showing, right click on the border and select format comment to get the dialogue box Kris shows. But I find that automatic size is no good as it puts it all in one line. Better just to use the drag handles on the comment box border to size the box.
 

Forum statistics

Threads
1,136,425
Messages
5,675,770
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top