A
Alan
Is there a technique in Excel which allows the user to
enter lengthy text info in a cell and view/print the
info?
I'm using Excel to create multipage forms which are
filled out by a user. The user must enter text
information on several pages. The text may be a few
sentences or several pages. I would also like to include
references in the text to cell values. For example,
provide several names on the text page via cell
references, then allow the user to type comments after
each name.
Excel 2003 limits the cell text contents to 32,767 char
with a max cell display of 1,024 and 32,767 displayed in
the forumula bar. The cell display appears to be further
limited by the max vertical cell size adjustment (my page
width needs to match legal size paper layout, i expand
the cell height to the max).
When I entered approx 3,000 char in a cell, approx 2,500
char were viewable in the cell and all the char were
viewable in the formula bar.
When I print the worksheet, only the text visible in the
cell is printed. This is unacceptable.
I've tried inserting a Word Object for the lengthy text.
I could create hyperlinks to cells to include the cell
values in the Word Object with the user typed text.
Unfortunately, the Word Object did not print over 1 page
so this is unacceptable.
Any suggestions are appreciated.
thanks.
enter lengthy text info in a cell and view/print the
info?
I'm using Excel to create multipage forms which are
filled out by a user. The user must enter text
information on several pages. The text may be a few
sentences or several pages. I would also like to include
references in the text to cell values. For example,
provide several names on the text page via cell
references, then allow the user to type comments after
each name.
Excel 2003 limits the cell text contents to 32,767 char
with a max cell display of 1,024 and 32,767 displayed in
the forumula bar. The cell display appears to be further
limited by the max vertical cell size adjustment (my page
width needs to match legal size paper layout, i expand
the cell height to the max).
When I entered approx 3,000 char in a cell, approx 2,500
char were viewable in the cell and all the char were
viewable in the formula bar.
When I print the worksheet, only the text visible in the
cell is printed. This is unacceptable.
I've tried inserting a Word Object for the lengthy text.
I could create hyperlinks to cells to include the cell
values in the Word Object with the user typed text.
Unfortunately, the Word Object did not print over 1 page
so this is unacceptable.
Any suggestions are appreciated.
thanks.