Display.

Nigel Martin · May 13th, 2002, 12:02 PM

I have a spreadsheet with a comments heading in a column. Some comments can be upward of around 1500 charsacters (including spaces etc.). By merging and resizing the cells I can only get Excel to display around 1100 characters. Any ideas?

Corticus · May 13th, 2002, 12:44 PM

I just tried putting about a million A's in a text box and inserting that in the sheet. Seemed to work pretty well...

HTH,
Corticus

Damon Ostrander · May 13th, 2002, 12:47 PM

Hi Nigel,

I suggest you use a real comment rather than typing the comment in as the cell value. Once the data is entered into a cell comment you can scale the comment box to fit over the cell and a comment is not limited to displaying only 1024 characters. Insert the comment using menu Insert -> Comment, and keep it visible using View -> Comments.

If you have lots of these, it would be fairly easy to write a VBA macro that automates moving and scaling all the comments and setting row height on a worksheet to display on top of the cells that contain them rather than displaying off to the side.

Nigel Martin · May 13th, 2002, 12:51 PM

I have already tried that. Think of it as a very cell just 1 of many others that you can then use auto filter on etc. eg cell D1 has 1500 characters and cell D2 has 1100 characters etc.

Nigel Martin · May 13th, 2002, 12:53 PM

Sorry Damon my previous reply was to Corticus.

Mark W. · May 13th, 2002, 03:46 PM

See http://support.microsoft.com/default...;en-us;Q156881

May 13th, 2002, 12:47 PM	#3
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 3,884	Hi Nigel, I suggest you use a real comment rather than typing the comment in as the cell value. Once the data is entered into a cell comment you can scale the comment box to fit over the cell and a comment is not limited to displaying only 1024 characters. Insert the comment using menu Insert -> Comment, and keep it visible using View -> Comments. If you have lots of these, it would be fairly easy to write a VBA macro that automates moving and scaling all the comments and setting row height on a worksheet to display on top of the cells that contain them rather than displaying off to the side. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 12:02 PM	#1
Nigel Martin Join Date: Feb 2002 Posts: 133	I have a spreadsheet with a comments heading in a column. Some comments can be upward of around 1500 charsacters (including spaces etc.). By merging and resizing the cells I can only get Excel to display around 1100 characters. Any ideas?

May 13th, 2002, 12:44 PM	#2
Corticus Join Date: May 2002 Location: Sarasota, FL Posts: 1,539	I just tried putting about a million A's in a text box and inserting that in the sheet. Seemed to work pretty well... HTH, Corticus

May 13th, 2002, 12:51 PM	#4
Nigel Martin Join Date: Feb 2002 Posts: 133	I have already tried that. Think of it as a very cell just 1 of many others that you can then use auto filter on etc. eg cell D1 has 1500 characters and cell D2 has 1100 characters etc.

May 13th, 2002, 12:53 PM	#5
Nigel Martin Join Date: Feb 2002 Posts: 133	Sorry Damon my previous reply was to Corticus.

May 13th, 2002, 03:46 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,653	See http://support.microsoft.com/default...;en-us;Q156881