Why “trace dependents” shortcut is not working in excel?
I have found out that "Trace dependents" shortcut Ctrl+[ is not working on particular Excel installations. For example, my colleague's Excel 2010 does not recognize Ctrl+[ while this shortcut perfectly works for me. We have same notebooks, our Windows and Office versions were installed from the same corporate installation package and are absolutely identical.
My home computer version of Excel 2013 has this problem too - Ctrl+[ shortcut is not working.
I have tried to search for solution, but it seems that this shortcut is not widely used (although being extremely handy in my opinion) and I found no solution.
Could anyone advise how can I enable this shortcut at least in Excel 2013.
microsoft-excel keyboard-shortcuts shortcuts
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
add a comment |
I have found out that "Trace dependents" shortcut Ctrl+[ is not working on particular Excel installations. For example, my colleague's Excel 2010 does not recognize Ctrl+[ while this shortcut perfectly works for me. We have same notebooks, our Windows and Office versions were installed from the same corporate installation package and are absolutely identical.
My home computer version of Excel 2013 has this problem too - Ctrl+[ shortcut is not working.
I have tried to search for solution, but it seems that this shortcut is not widely used (although being extremely handy in my opinion) and I found no solution.
Could anyone advise how can I enable this shortcut at least in Excel 2013.
microsoft-excel keyboard-shortcuts shortcuts
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53
add a comment |
I have found out that "Trace dependents" shortcut Ctrl+[ is not working on particular Excel installations. For example, my colleague's Excel 2010 does not recognize Ctrl+[ while this shortcut perfectly works for me. We have same notebooks, our Windows and Office versions were installed from the same corporate installation package and are absolutely identical.
My home computer version of Excel 2013 has this problem too - Ctrl+[ shortcut is not working.
I have tried to search for solution, but it seems that this shortcut is not widely used (although being extremely handy in my opinion) and I found no solution.
Could anyone advise how can I enable this shortcut at least in Excel 2013.
microsoft-excel keyboard-shortcuts shortcuts
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
I have found out that "Trace dependents" shortcut Ctrl+[ is not working on particular Excel installations. For example, my colleague's Excel 2010 does not recognize Ctrl+[ while this shortcut perfectly works for me. We have same notebooks, our Windows and Office versions were installed from the same corporate installation package and are absolutely identical.
My home computer version of Excel 2013 has this problem too - Ctrl+[ shortcut is not working.
I have tried to search for solution, but it seems that this shortcut is not widely used (although being extremely handy in my opinion) and I found no solution.
Could anyone advise how can I enable this shortcut at least in Excel 2013.
microsoft-excel keyboard-shortcuts shortcuts
microsoft-excel keyboard-shortcuts shortcuts
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
asked Nov 27 '16 at 11:31
Denis AvdoninDenis Avdonin
612
612
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53
add a comment |
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53
add a comment |
2 Answers
2
active
oldest
votes
Click on the data-cell and touch:
Alt then m then d
as three separate keystrokes and you should create an arrow to the dependent formula-cell.
EDIT#1:
Starting with an empty worksheet, place 1 in A1 and place the formula:
=A1
in cell A2.
If you click on the data-cell A1 and touch Ctrl+] you should jump to the formula-cell A2.
If you click on the formula-cell A2 and touch Ctrl+[ you should jump back to the data-cell A1.
(remember to start with an empty worksheet)
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
|
show 1 more comment
I recommend checking that multiple Sheets are not selected in the Workbook (usually displayed near bottom of the interface). This condition is also indicated by “Group” appearing near the file name in Excel 2016. When a “Group” is selected, Trace Dependents is not available/grayed-out.
Group selected:
Single sheet only selected:
answered Feb 16 at 13:07
BenBen
1
add a comment |
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%2f1150214%2fwhy-trace-dependents-shortcut-is-not-working-in-excel%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
Click on the data-cell and touch:
Alt then m then d
as three separate keystrokes and you should create an arrow to the dependent formula-cell.
EDIT#1:
Starting with an empty worksheet, place 1 in A1 and place the formula:
=A1
in cell A2.
If you click on the data-cell A1 and touch Ctrl+] you should jump to the formula-cell A2.
If you click on the formula-cell A2 and touch Ctrl+[ you should jump back to the data-cell A1.
(remember to start with an empty worksheet)
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
|
show 1 more comment
Click on the data-cell and touch:
Alt then m then d
as three separate keystrokes and you should create an arrow to the dependent formula-cell.
EDIT#1:
Starting with an empty worksheet, place 1 in A1 and place the formula:
=A1
in cell A2.
If you click on the data-cell A1 and touch Ctrl+] you should jump to the formula-cell A2.
If you click on the formula-cell A2 and touch Ctrl+[ you should jump back to the data-cell A1.
(remember to start with an empty worksheet)
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
|
show 1 more comment
Click on the data-cell and touch:
Alt then m then d
as three separate keystrokes and you should create an arrow to the dependent formula-cell.
EDIT#1:
Starting with an empty worksheet, place 1 in A1 and place the formula:
=A1
in cell A2.
If you click on the data-cell A1 and touch Ctrl+] you should jump to the formula-cell A2.
If you click on the formula-cell A2 and touch Ctrl+[ you should jump back to the data-cell A1.
(remember to start with an empty worksheet)
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
Click on the data-cell and touch:
Alt then m then d
as three separate keystrokes and you should create an arrow to the dependent formula-cell.
EDIT#1:
Starting with an empty worksheet, place 1 in A1 and place the formula:
=A1
in cell A2.
If you click on the data-cell A1 and touch Ctrl+] you should jump to the formula-cell A2.
If you click on the formula-cell A2 and touch Ctrl+[ you should jump back to the data-cell A1.
(remember to start with an empty worksheet)
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
edited Nov 27 '16 at 13:39
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
answered Nov 27 '16 at 12:47
Gary's StudentGary's Student
14.2k31733
14.2k31733
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
|
show 1 more comment
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
1
1
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
Thank you for your reply. ALT-M-D shows the arrows (and actually is the shortcut to "Trace dependents" button in the ribbon) which is not the same as what Ctrl+[ is doing. Possibly, I should be using another description, because there no such button in the ribbon, which selects the cells in the formula.
– Denis Avdonin
Nov 27 '16 at 12:59
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
@DenisAvdonin See my EDIT#1
– Gary's Student
Nov 27 '16 at 13:31
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
I did exactly what you suggested, but nothing happens when I press Ctrl+[, I have tried both new empty workbook and existing workbook with lots of formulas. This is the problem that I'm trying to find solution for - Ctrl+[ shortcut is not working.
– Denis Avdonin
Nov 27 '16 at 15:54
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
@DenisAvdonin Are both Ctrl+] and Ctrl+[ not working ???
– Gary's Student
Nov 27 '16 at 16:04
1
1
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
Yes, both of them are not working.
– Denis Avdonin
Nov 28 '16 at 12:07
|
show 1 more comment
I recommend checking that multiple Sheets are not selected in the Workbook (usually displayed near bottom of the interface). This condition is also indicated by “Group” appearing near the file name in Excel 2016. When a “Group” is selected, Trace Dependents is not available/grayed-out.
Group selected:
Single sheet only selected:
answered Feb 16 at 13:07
BenBen
1
add a comment |
I recommend checking that multiple Sheets are not selected in the Workbook (usually displayed near bottom of the interface). This condition is also indicated by “Group” appearing near the file name in Excel 2016. When a “Group” is selected, Trace Dependents is not available/grayed-out.
Group selected:
Single sheet only selected:
answered Feb 16 at 13:07
BenBen
1
add a comment |
I recommend checking that multiple Sheets are not selected in the Workbook (usually displayed near bottom of the interface). This condition is also indicated by “Group” appearing near the file name in Excel 2016. When a “Group” is selected, Trace Dependents is not available/grayed-out.
Group selected:
Single sheet only selected:
answered Feb 16 at 13:07
BenBen
1
I recommend checking that multiple Sheets are not selected in the Workbook (usually displayed near bottom of the interface). This condition is also indicated by “Group” appearing near the file name in Excel 2016. When a “Group” is selected, Trace Dependents is not available/grayed-out.
Group selected:
Single sheet only selected:
answered Feb 16 at 13:07
BenBen
1
answered Feb 16 at 13:07
BenBen
1
answered Feb 16 at 13:07
BenBen
1
answered Feb 16 at 13:07
BenBen
1
1
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.
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%2f1150214%2fwhy-trace-dependents-shortcut-is-not-working-in-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
What Ribbon Tab is active when you touch Ctrl + [ ??
– Gary's Student
Nov 27 '16 at 12:11
I should explain that shortcut Ctrl+[ I am referring to does not put arrows showing which cells are dependent on this one, but it moves cursor to cells in the formula. For example, if you press Ctrl+[ on cell where formula is "SUM(D1:D6)" it will move selection to cells "D1:D6" rather than show arrows.
– Denis Avdonin
Nov 27 '16 at 12:53