View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Can a Text Box be Formatted in Columns?

You might consider typing your text in columns on another helper sheet, in
the columns as you wish.........then highlight the cells, do Ctrl-Shift-Edit
Copy Picture, and then paste it into a Text box......again, not very handy,

but looks a lot better.

Vaya con Dios,
Chuck, CABGx3



"Wuddus" wrote:

I have a large text box which holds quite a bit of text. Ideally the text it
contains would be formatted into columns. Is this possible? I've tried just
manually making columns in the box by inserting spaces after the end of a
line and then typing more text, doing this for each line, but A) this is
horribly awkward to edit, and B) it looks crappy.

I've also tried grouping narrower text boxes together, creating the effect
of columns. This actually isn't so bad, but you have to ungroup them to
edit, and since text doesn't flow from one to the other, it's kind of limited
and again awkward to work with.

Is there a better way to do what I need to do?