Why is the shortcut missing for EDIT/FILL/JUSTIFY from excel?
I use Microsoft Excel 2010 and I am no longer able to find the shortcut icon that allowed me to use "EDIT/FILL/JUSTIFY" by just clicking on the icon.
Please note that there ase two "justify" within excel - One "concatenates" the text from a number of cells into one cell and the other evens out the text within the cell. I am after the icon for the the Justify that concatenates
Does anyone know how to do this in excel 2010?
microsoft-excel-2010 shortcuts
asked Mar 26 '13 at 11:25
Jim
613
add a comment |
I use Microsoft Excel 2010 and I am no longer able to find the shortcut icon that allowed me to use "EDIT/FILL/JUSTIFY" by just clicking on the icon.
Please note that there ase two "justify" within excel - One "concatenates" the text from a number of cells into one cell and the other evens out the text within the cell. I am after the icon for the the Justify that concatenates
Does anyone know how to do this in excel 2010?
microsoft-excel-2010 shortcuts
asked Mar 26 '13 at 11:25
Jim
613
2
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59
add a comment |
I use Microsoft Excel 2010 and I am no longer able to find the shortcut icon that allowed me to use "EDIT/FILL/JUSTIFY" by just clicking on the icon.
Please note that there ase two "justify" within excel - One "concatenates" the text from a number of cells into one cell and the other evens out the text within the cell. I am after the icon for the the Justify that concatenates
Does anyone know how to do this in excel 2010?
microsoft-excel-2010 shortcuts
asked Mar 26 '13 at 11:25
Jim
613
I use Microsoft Excel 2010 and I am no longer able to find the shortcut icon that allowed me to use "EDIT/FILL/JUSTIFY" by just clicking on the icon.
Please note that there ase two "justify" within excel - One "concatenates" the text from a number of cells into one cell and the other evens out the text within the cell. I am after the icon for the the Justify that concatenates
Does anyone know how to do this in excel 2010?
microsoft-excel-2010 shortcuts
microsoft-excel-2010 shortcuts
asked Mar 26 '13 at 11:25
Jim
613
asked Mar 26 '13 at 11:25
Jim
613
edited Mar 26 '13 at 13:12
asked Mar 26 '13 at 11:25
Jim
613
asked Mar 26 '13 at 11:25
Jim
613
asked Mar 26 '13 at 11:25
Jim
613
613
2
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59
add a comment |
2
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59
2
2
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59
add a comment |
5 Answers
5
active
oldest
votes
Are you looking for the Fill → Justify command? It's in the Home tab in the Editing section. The middle icon on the left (the one with the down arrow) is for Fill. The last item in the menu is Justify.
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
add a comment |
Unless I've misunderstood your question, I think that you mean "Merge & Centre"? This is on the right hand side of the "Alignment" section of the Home bar.
It merges the selected cells and centres the result.
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
add a comment |
"[Alt]+EIJ" -- Use the old short cut keys: Highlight your text area and go [Alt]+E, then I, then J. There also is a "FILL" icon in the home/edit ribbon: "up, down, left right, across worksheets, series and justify".
answered Jul 24 '14 at 12:54
tom
1
add a comment |
The ALT-E; I; J function works just fine for people like us who are used to the old menus.
The problem is how to find the equivalent set of commands in the newer versions of Excel with Newer Menus. Is it possible that they forgot to port this command to the new UI, but left the funcionality behind?
answered Dec 14 at 22:14
Skibear99
62
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
add a comment |
A little searching in the menus took me to: Home--> Fill--> [Dropdown] --> Justify.
This is how they like to do it now.
FWIW, I've found free executables which will give you and the users you support the Old Windows/Office `97 Menus.
answered Dec 14 at 22:19
Skibear99
62
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%2f571645%2fwhy-is-the-shortcut-missing-for-edit-fill-justify-from-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
5 Answers
5
active
oldest
votes
5 Answers
5
active
oldest
votes
active
oldest
votes
active
oldest
votes
Are you looking for the Fill → Justify command? It's in the Home tab in the Editing section. The middle icon on the left (the one with the down arrow) is for Fill. The last item in the menu is Justify.
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
add a comment |
Are you looking for the Fill → Justify command? It's in the Home tab in the Editing section. The middle icon on the left (the one with the down arrow) is for Fill. The last item in the menu is Justify.
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
add a comment |
Are you looking for the Fill → Justify command? It's in the Home tab in the Editing section. The middle icon on the left (the one with the down arrow) is for Fill. The last item in the menu is Justify.
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
Are you looking for the Fill → Justify command? It's in the Home tab in the Editing section. The middle icon on the left (the one with the down arrow) is for Fill. The last item in the menu is Justify.
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
answered Mar 26 '13 at 14:47
Brad Patton
9,141123366
9,141123366
add a comment |
add a comment |
Unless I've misunderstood your question, I think that you mean "Merge & Centre"? This is on the right hand side of the "Alignment" section of the Home bar.
It merges the selected cells and centres the result.
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
add a comment |
Unless I've misunderstood your question, I think that you mean "Merge & Centre"? This is on the right hand side of the "Alignment" section of the Home bar.
It merges the selected cells and centres the result.
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
add a comment |
Unless I've misunderstood your question, I think that you mean "Merge & Centre"? This is on the right hand side of the "Alignment" section of the Home bar.
It merges the selected cells and centres the result.
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
Unless I've misunderstood your question, I think that you mean "Merge & Centre"? This is on the right hand side of the "Alignment" section of the Home bar.
It merges the selected cells and centres the result.
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
answered Mar 26 '13 at 13:19
Julian Knight
12.9k11535
12.9k11535
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
add a comment |
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
Thanks but No - my "justify" brings the content/text of the cells I choose to highlight into one cell - "merge" combines a number of cells into one and only retains the text for one cell
– Jim
Mar 26 '13 at 14:15
add a comment |
"[Alt]+EIJ" -- Use the old short cut keys: Highlight your text area and go [Alt]+E, then I, then J. There also is a "FILL" icon in the home/edit ribbon: "up, down, left right, across worksheets, series and justify".
answered Jul 24 '14 at 12:54
tom
1
add a comment |
"[Alt]+EIJ" -- Use the old short cut keys: Highlight your text area and go [Alt]+E, then I, then J. There also is a "FILL" icon in the home/edit ribbon: "up, down, left right, across worksheets, series and justify".
answered Jul 24 '14 at 12:54
tom
1
add a comment |
"[Alt]+EIJ" -- Use the old short cut keys: Highlight your text area and go [Alt]+E, then I, then J. There also is a "FILL" icon in the home/edit ribbon: "up, down, left right, across worksheets, series and justify".
answered Jul 24 '14 at 12:54
tom
1
"[Alt]+EIJ" -- Use the old short cut keys: Highlight your text area and go [Alt]+E, then I, then J. There also is a "FILL" icon in the home/edit ribbon: "up, down, left right, across worksheets, series and justify".
answered Jul 24 '14 at 12:54
tom
1
answered Jul 24 '14 at 12:54
tom
1
answered Jul 24 '14 at 12:54
tom
1
answered Jul 24 '14 at 12:54
tom
1
1
add a comment |
add a comment |
The ALT-E; I; J function works just fine for people like us who are used to the old menus.
The problem is how to find the equivalent set of commands in the newer versions of Excel with Newer Menus. Is it possible that they forgot to port this command to the new UI, but left the funcionality behind?
answered Dec 14 at 22:14
Skibear99
62
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
add a comment |
The ALT-E; I; J function works just fine for people like us who are used to the old menus.
The problem is how to find the equivalent set of commands in the newer versions of Excel with Newer Menus. Is it possible that they forgot to port this command to the new UI, but left the funcionality behind?
answered Dec 14 at 22:14
Skibear99
62
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
add a comment |
The ALT-E; I; J function works just fine for people like us who are used to the old menus.
The problem is how to find the equivalent set of commands in the newer versions of Excel with Newer Menus. Is it possible that they forgot to port this command to the new UI, but left the funcionality behind?
answered Dec 14 at 22:14
Skibear99
62
The ALT-E; I; J function works just fine for people like us who are used to the old menus.
The problem is how to find the equivalent set of commands in the newer versions of Excel with Newer Menus. Is it possible that they forgot to port this command to the new UI, but left the funcionality behind?
answered Dec 14 at 22:14
Skibear99
62
answered Dec 14 at 22:14
Skibear99
62
answered Dec 14 at 22:14
Skibear99
62
answered Dec 14 at 22:14
Skibear99
62
62
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
add a comment |
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
Welcome to Super User. Instead of posting a second answer, please edit your first one. Also, please do not ask questions in the answer box.
– Twisty Impersonator
Dec 14 at 22:38
add a comment |
A little searching in the menus took me to: Home--> Fill--> [Dropdown] --> Justify.
This is how they like to do it now.
FWIW, I've found free executables which will give you and the users you support the Old Windows/Office `97 Menus.
answered Dec 14 at 22:19
Skibear99
62
add a comment |
A little searching in the menus took me to: Home--> Fill--> [Dropdown] --> Justify.
This is how they like to do it now.
FWIW, I've found free executables which will give you and the users you support the Old Windows/Office `97 Menus.
answered Dec 14 at 22:19
Skibear99
62
add a comment |
A little searching in the menus took me to: Home--> Fill--> [Dropdown] --> Justify.
This is how they like to do it now.
FWIW, I've found free executables which will give you and the users you support the Old Windows/Office `97 Menus.
answered Dec 14 at 22:19
Skibear99
62
A little searching in the menus took me to: Home--> Fill--> [Dropdown] --> Justify.
This is how they like to do it now.
FWIW, I've found free executables which will give you and the users you support the Old Windows/Office `97 Menus.
answered Dec 14 at 22:19
Skibear99
62
answered Dec 14 at 22:19
Skibear99
62
answered Dec 14 at 22:19
Skibear99
62
answered Dec 14 at 22:19
Skibear99
62
62
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f571645%2fwhy-is-the-shortcut-missing-for-edit-fill-justify-from-excel%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
2
Welcome to Superuser. Your question is confusing because you are talking about two things. Please read How to Ask and then edit your question to clarify what you are asking.
– CharlieRB
Mar 26 '13 at 11:59