What does the “Justify Distributed” alignment really do?
In Excel 2010 in Alignment tab of Format Cells there is a check box named Justify Distributed.
What does this option do?
microsoft-excel microsoft-excel-2010
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
add a comment |
In Excel 2010 in Alignment tab of Format Cells there is a check box named Justify Distributed.
What does this option do?
microsoft-excel microsoft-excel-2010
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
add a comment |
In Excel 2010 in Alignment tab of Format Cells there is a check box named Justify Distributed.
What does this option do?
microsoft-excel microsoft-excel-2010
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
In Excel 2010 in Alignment tab of Format Cells there is a check box named Justify Distributed.
What does this option do?
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
asked Jun 24 '14 at 5:58
abbasiabbasi
842518
842518
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Justify Distributed is a type of alignment wherein the first and last word of each line is aligned to the left and right margin respectively. As for the case of Excel, it will align to the left and right borders of that row. Excel will also be the one responsible for the spacing between words so they'll be distributed evenly across the line.
If you choose Distributed (Indent), you can choose what value your Indent should be. Indent tells how many indent spaces will you have after your left border and before your right border. Checking the "Justify Distributed" box is the same as keeping this number to 0 wherein the first and last word is just aligned to the left and right borders respectively.
Checking the "Justify Distributed" disables the "Indent" option and this ensures that there are no spaces between the left border and the first word; and the last word and the right border.
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
add a comment |
If you have your Horizontal Alignment set to 'Distributed', then checking the Justify Distributed checkbox will make characters in the cell to the left of the space character left aligned, and characters on the right of the space character right aligned.
This is what content in a Justify Distributed cell looks like. The cell contains: 'the quick':
It's like having left and right justification in the same cell.
EDIT:
The difference between Justify Distributed and Distributed only comes into play with a multi-line cell. In a Justify Distributed cell, the last line of text is fully justified. See second attached image where row 2 is Distributed and row 3 is Justify Distributed. 
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f772640%2fwhat-does-the-justify-distributed-alignment-really-do%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Justify Distributed is a type of alignment wherein the first and last word of each line is aligned to the left and right margin respectively. As for the case of Excel, it will align to the left and right borders of that row. Excel will also be the one responsible for the spacing between words so they'll be distributed evenly across the line.
If you choose Distributed (Indent), you can choose what value your Indent should be. Indent tells how many indent spaces will you have after your left border and before your right border. Checking the "Justify Distributed" box is the same as keeping this number to 0 wherein the first and last word is just aligned to the left and right borders respectively.
Checking the "Justify Distributed" disables the "Indent" option and this ensures that there are no spaces between the left border and the first word; and the last word and the right border.
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
add a comment |
Justify Distributed is a type of alignment wherein the first and last word of each line is aligned to the left and right margin respectively. As for the case of Excel, it will align to the left and right borders of that row. Excel will also be the one responsible for the spacing between words so they'll be distributed evenly across the line.
If you choose Distributed (Indent), you can choose what value your Indent should be. Indent tells how many indent spaces will you have after your left border and before your right border. Checking the "Justify Distributed" box is the same as keeping this number to 0 wherein the first and last word is just aligned to the left and right borders respectively.
Checking the "Justify Distributed" disables the "Indent" option and this ensures that there are no spaces between the left border and the first word; and the last word and the right border.
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
add a comment |
Justify Distributed is a type of alignment wherein the first and last word of each line is aligned to the left and right margin respectively. As for the case of Excel, it will align to the left and right borders of that row. Excel will also be the one responsible for the spacing between words so they'll be distributed evenly across the line.
If you choose Distributed (Indent), you can choose what value your Indent should be. Indent tells how many indent spaces will you have after your left border and before your right border. Checking the "Justify Distributed" box is the same as keeping this number to 0 wherein the first and last word is just aligned to the left and right borders respectively.
Checking the "Justify Distributed" disables the "Indent" option and this ensures that there are no spaces between the left border and the first word; and the last word and the right border.
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
Justify Distributed is a type of alignment wherein the first and last word of each line is aligned to the left and right margin respectively. As for the case of Excel, it will align to the left and right borders of that row. Excel will also be the one responsible for the spacing between words so they'll be distributed evenly across the line.
If you choose Distributed (Indent), you can choose what value your Indent should be. Indent tells how many indent spaces will you have after your left border and before your right border. Checking the "Justify Distributed" box is the same as keeping this number to 0 wherein the first and last word is just aligned to the left and right borders respectively.
Checking the "Justify Distributed" disables the "Indent" option and this ensures that there are no spaces between the left border and the first word; and the last word and the right border.
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
edited Jun 24 '14 at 7:18
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
answered Jun 24 '14 at 7:11
Batibot323Batibot323
133
133
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
add a comment |
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
No. It doesn't disable it. It only grays the Indent but using it is still possible. Thanks for your answer.
– abbasi
Jun 24 '14 at 7:28
add a comment |
If you have your Horizontal Alignment set to 'Distributed', then checking the Justify Distributed checkbox will make characters in the cell to the left of the space character left aligned, and characters on the right of the space character right aligned.
This is what content in a Justify Distributed cell looks like. The cell contains: 'the quick':
It's like having left and right justification in the same cell.
EDIT:
The difference between Justify Distributed and Distributed only comes into play with a multi-line cell. In a Justify Distributed cell, the last line of text is fully justified. See second attached image where row 2 is Distributed and row 3 is Justify Distributed.
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
add a comment |
If you have your Horizontal Alignment set to 'Distributed', then checking the Justify Distributed checkbox will make characters in the cell to the left of the space character left aligned, and characters on the right of the space character right aligned.
This is what content in a Justify Distributed cell looks like. The cell contains: 'the quick':
It's like having left and right justification in the same cell.
EDIT:
The difference between Justify Distributed and Distributed only comes into play with a multi-line cell. In a Justify Distributed cell, the last line of text is fully justified. See second attached image where row 2 is Distributed and row 3 is Justify Distributed.
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
add a comment |
If you have your Horizontal Alignment set to 'Distributed', then checking the Justify Distributed checkbox will make characters in the cell to the left of the space character left aligned, and characters on the right of the space character right aligned.
This is what content in a Justify Distributed cell looks like. The cell contains: 'the quick':
It's like having left and right justification in the same cell.
EDIT:
The difference between Justify Distributed and Distributed only comes into play with a multi-line cell. In a Justify Distributed cell, the last line of text is fully justified. See second attached image where row 2 is Distributed and row 3 is Justify Distributed.
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
If you have your Horizontal Alignment set to 'Distributed', then checking the Justify Distributed checkbox will make characters in the cell to the left of the space character left aligned, and characters on the right of the space character right aligned.
This is what content in a Justify Distributed cell looks like. The cell contains: 'the quick':
It's like having left and right justification in the same cell.
EDIT:
The difference between Justify Distributed and Distributed only comes into play with a multi-line cell. In a Justify Distributed cell, the last line of text is fully justified. See second attached image where row 2 is Distributed and row 3 is Justify Distributed.
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
edited Jun 24 '14 at 9:02
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
answered Jun 24 '14 at 6:06
mcalexmcalex
2,227815
2,227815
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
add a comment |
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
But there isn't apparently any difference between that state and the Horizontal Distributed (if we uncheck the justify distributed).
– abbasi
Jun 24 '14 at 7:03
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
I tested that text. The A2 is not Distributed! While the A3 is Justify distributed. If you apply the Distributed over A2 you'll see there isn't any difference between them. Thanks for your trying to help.
– abbasi
Jun 24 '14 at 12:57
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
oops, yep, I was testing with the 'Indent' value in row 2. You're right. Justify Distributed does nothing. Interestingly, in vba, it looks like there are only constants for 'center', 'distributed', 'justify', 'left' and 'right', not 'justify distributed', so I think its a 'not yet implemented' feature.
– mcalex
Jun 25 '14 at 2:50
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f772640%2fwhat-does-the-justify-distributed-alignment-really-do%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
