LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
RUSH2CROCHET
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeat printing rows in multiple worksheets KevinG Excel Discussion (Misc queries) 19 November 27th 07 10:42 PM
mail merging 2 workbooks??? Bubba Gump Excel Discussion (Misc queries) 21 August 7th 06 09:13 AM
Deleting Duplicate items in a ListBox CLamar Excel Discussion (Misc queries) 24 June 13th 06 06:22 PM
opening text file in excel problem jz193 Excel Discussion (Misc queries) 18 February 10th 06 02:42 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"