View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default Lots of text in one cell

Hi
Tricky to do in a consistent, automated and attractive way. Excel
doesn't do attractive on the whole. You would have to get into
character widths I reckon - more trouble than it is worth?
I would just set the column width and turn on text wrapping for that
column (Cell format, alignment, wrap text).
regards
Paul

On Feb 26, 8:42*am, "Robert Crandal" wrote:
After I click on File-New, Excel will begin with a default size empty
sheet. *If I type a long, say 100+ character, string into cell A1 then
that text will visibly spill over in the adjacent cells.

Is there a way to tell Excel to resize or redimension cell A1 so that
my string completely fills the cell in a nice looking manner??? *I
basically want any arbitrary string that I type to completely visible
and contained within cell A1 in a nice looking way.

thank you