ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format, Cells, Alignment. (https://www.excelbanter.com/excel-discussion-misc-queries/198393-format-cells-alignment.html)

Highland Cow[_2_]

Format, Cells, Alignment.
 
If you choose Distributed in the Horizontal Alignment section when your text
is vertical, in the orientation section, the Justify Distributed check box
becomes active. I cannot see any difference in the textwhen this box is or
isn't selected but when I teach it on Wednesday someone is bound to ask what
it does. Does anyone know.

Thanks

J Sedoff comRemove>

Format, Cells, Alignment.
 
I also do not see a difference, and after a moderate Google search, no
relevant results. I imagine back in the day of old computers it might do
something... who knows.

Justify: spreads the text to align both left and right for _one line_.
Distributed: same as Justify, but for multiple lines (when your text wraps
to create more than one line of text).

Hope this helps, Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes,"
I/someone else did answer your question. Thank you.

Highland Cow[_2_]

Format, Cells, Alignment.
 
Thanks Jim. Nice to know it's not just me. It's "new" in 2003 so I assume
they added it for a reason. Someone else says, "It distributes the words in
your cell so they fill the entire cell. The first word will be left
justified, the last word will be right justified, and the words in between
will have the same amount of space between them." that's the same if I don't
tick it.

Cheers

Anne

"J Sedoff" wrote:

I also do not see a difference, and after a moderate Google search, no
relevant results. I imagine back in the day of old computers it might do
something... who knows.

Justify: spreads the text to align both left and right for _one line_.
Distributed: same as Justify, but for multiple lines (when your text wraps
to create more than one line of text).

Hope this helps, Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes,"
I/someone else did answer your question. Thank you.



All times are GMT +1. The time now is 01:35 PM.

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