MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comments Boxes


Posted by Ampleford on December 19, 2001 11:56 PM

Can anyone tell me how to get the Comments boxes to stretch accross three cells. I have three adjacent cells which all require the same comment. The spread looks ugly when the three comment boxes are open

Who can help ?


Posted by Chris D on December 20, 2001 3:30 AM

Assuming they're always visible, could you right click on them then just drag two of the three so that they just sit ontop of the third ? This would result in 1 box with three little arrows pointing to each cell...

HTH
Chris

Posted by ampleford on December 21, 2001 1:00 AM

Thanks a lot - really an obvious solution - probably why this board was invented -


Have a good Christmas etc etc