How DO I Increase The Excel Cell Comment Data Capacity?

[Rob Sandifer]

Greetings,

I am running: Microsoft Office Excel 2003 (11.8316.8221) SP3

My question is this:

Is there a way for me to increase the maximum amount of data that an
Excel spreadsheet "cell comment" will hold?

Whenever I am working inside a .XLS spreadsheet, I frequently make use
of the "cell comment" feature which allows me to make special notes or
comments
on selected spreadsheet cells. The problem is that sometimes when I am
copying and pasting large amounts of data into the cell comments box that
holds the comment, Excel seems to allow me to paste only so much data into
the cell comment box and then it will not let me add any more comments/data.

So again, is there a way for me to increase the maximum amount of data that
an
Excel spreadsheet "cell comment" will hold?.

All sincere/thoughtful replies are solicited and appreciated!

Regards,

Rob Sandifer

 

[Gord Dibben]

How much is "only so much"?

I tested with 10000 characters being entered into a comment and had no
problem fitting them in.

Sizing the Comment to show all text was not so easy<g>

Excel 2003 in use.


Gord Dibben MS Excel MVP

On Fri, 4 Dec 2009 14:07:01 -0800, Rob Sandifer <Rob