ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Not all of the text is visible.... (Attn: Dave Peterson) (https://www.excelbanter.com/excel-discussion-misc-queries/97037-re-not-all-text-visible-attn-dave-peterson.html)

RUSH2CROCHET

Not all of the text is visible.... (Attn: Dave Peterson)
 
Dave:
Not sure if you get replies to old posts, but you posted the following
formula
(on 8/18/06-10:24 a.m. PST) in response to the above related issue.

I put this formula in A1:
="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
(edit|copy, edit|paste special|values if you want)
turn wrap text on.

And adjusted the columnwidth, rowheight and font size and I could see over
6000
characters.

Is there any way around the column width/row height/font size adjusting?
Working with "print" limitations on the hard document copy. Any advice you
can provide is appreciated.

TIA,
Sandi



Dave Peterson

Not all of the text is visible.... (Attn: Dave Peterson)
 
I don't have anything else--font size and alt-enters are the main two
workarounds.

Maybe a text box????

Maybe embedding an MSWord document???

Maybe adding a hyperlink to an MSWord document???



RUSH2CROCHET wrote:

Dave:
Not sure if you get replies to old posts, but you posted the following
formula
(on 8/18/06-10:24 a.m. PST) in response to the above related issue.

I put this formula in A1:
="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
(edit|copy, edit|paste special|values if you want)
turn wrap text on.

And adjusted the columnwidth, rowheight and font size and I could see over
6000
characters.

Is there any way around the column width/row height/font size adjusting?
Working with "print" limitations on the hard document copy. Any advice you
can provide is appreciated.

TIA,
Sandi


--

Dave Peterson


All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com