"justify across selection" cell formatting

[dgold82]

I have been trying to paste a large amount of text within a cell without
merging cells. I can only find the ability to center across selection which
works great except that the text is centered. I want to justify the text
instead, but I can't figure it out.

Help would be appreciated.

 

[Fred Smith]

I'm not sure what you would expect "center across selection" to do other
than center the text.

If you want to justify the text, then choose Justify as your Horizontal Text
Alignment. You might also want to select Wrap Text.

Regards,
Fred.

 

[Tom Hutchins]

Select the cell with the long text entry. Select Format >> Cells >>
Alignment. Put a check in the 'Wrap text' checkbox. Under Horizontal text
alignment, click Justify. Click OK. (Excel 2003)

Hope this helps,

Hutch

 

[dgold82]

Thanks, but really neither of your two suggestions work. I am trying to paste
a large word document within a worksheet and would like it in cells for
various reasons.

Center across selection allows me to fit the text across my worksheet
without having to merge the cells BUT the text is centered. I would merge the
cells but wrapping the text doesn't work with over 1,024 charachters and
there are other problems.

I have searched everywhere and it seems that other people are having this
problem as well with some macro solutions that work with wrapping the text
(but not for over 1,024 charachters). Thought there might be another solution
out there. Right now I am putting my paragraph headers in individual cells
and pasting the body text in text boxes. Looks fine, but is not efficient.

 

[Fred Smith]

Part of the reason our suggestions don't work is we were responding to your
first post where you said you were putting the text in a single cell. Now
you say you are putting the text in "cells".

What you've found out is why Microsoft developed two programs. Excel excels
at numbers, Word is for text.

Regards,
Fred.

 

[dgold82]

Fred, no need for sarcasm. I have been working on a large excel project for
months now. I have used this forum for many months with great success and
friendly exchange of ideas.

I apologize that my initial question wasn't clear. What I am trying to do is
copy a multipage word document (10 pages) within a worksheet. I first tried
to embed the document as an object but I couldn't figure out how to hyperlink
to various parts of the text from other worksheets in the workbook. My next
attempt was to copy the whole document and paste within cell A1. It ended up
pasting the seperate paragraphs in the subsequent cells (B1, D1 etc.).

Center across selection allowed me to specify the proper width (i.e. A1 to
F1) so that the text wouldn't go too far off the screen. I was trying to get
that same exact functionality but to left or justify the text. Merging A1 to
F1 and pasting in there doesn't work for the reason noted below.

Ideas would be appreciated. Hope I was more clear in this explanation.

 

[Fred Smith]

I still think you're better off using one cell (or more correctly, one
column).

You say that pasting puts "paragraphs in subsequent cells (B1, D1, etc.)"
But when I paste a Word document into Excel, it puts the paragraphs into
subsequent *rows* (A2, A3, etc.) all in one column. I can then apply Justify
and Word Wrap to the entire column and it looks pretty good.

If this is not what's happening when you paste, let us know.

If this is what's happening, and it's still not good enough, let us know
what you would like changed. In particular, what would you like Excel to do
at paragraph breaks?

Regards,
Fred.

Hope this helps,
Fred.