How to Link Cells in Column to Cell in Rows
I have an Excel database. I want to link Column cells to Row Cells. One by one doing this will take so much time. I want to use some formula. Please help. Apart from that I also want to link cells to each other. Means when i click on Cell in Column. It should take me to linked Row Cell. and when i click on same row cell, it should bring me back to same cell in column.
microsoft-excel microsoft-excel-2010 worksheet-function hyperlink
asked Apr 16 '16 at 10:12
Karry
1112
add a comment |
I have an Excel database. I want to link Column cells to Row Cells. One by one doing this will take so much time. I want to use some formula. Please help. Apart from that I also want to link cells to each other. Means when i click on Cell in Column. It should take me to linked Row Cell. and when i click on same row cell, it should bring me back to same cell in column.
microsoft-excel microsoft-excel-2010 worksheet-function hyperlink
asked Apr 16 '16 at 10:12
Karry
1112
add a comment |
I have an Excel database. I want to link Column cells to Row Cells. One by one doing this will take so much time. I want to use some formula. Please help. Apart from that I also want to link cells to each other. Means when i click on Cell in Column. It should take me to linked Row Cell. and when i click on same row cell, it should bring me back to same cell in column.
microsoft-excel microsoft-excel-2010 worksheet-function hyperlink
asked Apr 16 '16 at 10:12
Karry
1112
I have an Excel database. I want to link Column cells to Row Cells. One by one doing this will take so much time. I want to use some formula. Please help. Apart from that I also want to link cells to each other. Means when i click on Cell in Column. It should take me to linked Row Cell. and when i click on same row cell, it should bring me back to same cell in column.
microsoft-excel microsoft-excel-2010 worksheet-function hyperlink
microsoft-excel microsoft-excel-2010 worksheet-function hyperlink
asked Apr 16 '16 at 10:12
Karry
1112
asked Apr 16 '16 at 10:12
Karry
1112
asked Apr 16 '16 at 10:12
Karry
1112
asked Apr 16 '16 at 10:12
Karry
1112
asked Apr 16 '16 at 10:12
Karry
1112
1112
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If we have a column of data, say A1 through A21 and we want to link a row to it, pick a cell and enter:
=INDEX($A$1:$A$11,COLUMNS($A:A),0)
and copy across:
Once this is done, hyperlinks can be assigned either manually or through a VBA macro.
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
add a comment |
Perhaps the easiest way is this:
- Count the number of rows and columns in the Source range.
- Select a the Destination range of cells with the opposite number of rows and columns (e.g. if the original range had 3 columns and 2 rows, the target range would have 2 columns and 3 rows).
- With the Destination range cells selected, type "=TRANSPOSE(" (use Tab to autocomplete).
- Select the source rows
- Press Ctrl + Shift + Enter
The animation below demonstrates the process in Excel 2010 with a 1 row x 3 column scenario.
answered Nov 12 '17 at 11:07
MechtEngineer
259315
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%2f1066139%2fhow-to-link-cells-in-column-to-cell-in-rows%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
If we have a column of data, say A1 through A21 and we want to link a row to it, pick a cell and enter:
=INDEX($A$1:$A$11,COLUMNS($A:A),0)
and copy across:
Once this is done, hyperlinks can be assigned either manually or through a VBA macro.
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
add a comment |
If we have a column of data, say A1 through A21 and we want to link a row to it, pick a cell and enter:
=INDEX($A$1:$A$11,COLUMNS($A:A),0)
and copy across:
Once this is done, hyperlinks can be assigned either manually or through a VBA macro.
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
add a comment |
If we have a column of data, say A1 through A21 and we want to link a row to it, pick a cell and enter:
=INDEX($A$1:$A$11,COLUMNS($A:A),0)
and copy across:
Once this is done, hyperlinks can be assigned either manually or through a VBA macro.
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
If we have a column of data, say A1 through A21 and we want to link a row to it, pick a cell and enter:
=INDEX($A$1:$A$11,COLUMNS($A:A),0)
and copy across:
Once this is done, hyperlinks can be assigned either manually or through a VBA macro.
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
edited Apr 16 '16 at 11:51
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
answered Apr 16 '16 at 11:28
Gary's Student
13.3k31729
13.3k31729
add a comment |
add a comment |
Perhaps the easiest way is this:
- Count the number of rows and columns in the Source range.
- Select a the Destination range of cells with the opposite number of rows and columns (e.g. if the original range had 3 columns and 2 rows, the target range would have 2 columns and 3 rows).
- With the Destination range cells selected, type "=TRANSPOSE(" (use Tab to autocomplete).
- Select the source rows
- Press Ctrl + Shift + Enter
The animation below demonstrates the process in Excel 2010 with a 1 row x 3 column scenario.
answered Nov 12 '17 at 11:07
MechtEngineer
259315
add a comment |
Perhaps the easiest way is this:
- Count the number of rows and columns in the Source range.
- Select a the Destination range of cells with the opposite number of rows and columns (e.g. if the original range had 3 columns and 2 rows, the target range would have 2 columns and 3 rows).
- With the Destination range cells selected, type "=TRANSPOSE(" (use Tab to autocomplete).
- Select the source rows
- Press Ctrl + Shift + Enter
The animation below demonstrates the process in Excel 2010 with a 1 row x 3 column scenario.
answered Nov 12 '17 at 11:07
MechtEngineer
259315
add a comment |
Perhaps the easiest way is this:
- Count the number of rows and columns in the Source range.
- Select a the Destination range of cells with the opposite number of rows and columns (e.g. if the original range had 3 columns and 2 rows, the target range would have 2 columns and 3 rows).
- With the Destination range cells selected, type "=TRANSPOSE(" (use Tab to autocomplete).
- Select the source rows
- Press Ctrl + Shift + Enter
The animation below demonstrates the process in Excel 2010 with a 1 row x 3 column scenario.
answered Nov 12 '17 at 11:07
MechtEngineer
259315
Perhaps the easiest way is this:
- Count the number of rows and columns in the Source range.
- Select a the Destination range of cells with the opposite number of rows and columns (e.g. if the original range had 3 columns and 2 rows, the target range would have 2 columns and 3 rows).
- With the Destination range cells selected, type "=TRANSPOSE(" (use Tab to autocomplete).
- Select the source rows
- Press Ctrl + Shift + Enter
The animation below demonstrates the process in Excel 2010 with a 1 row x 3 column scenario.
answered Nov 12 '17 at 11:07
MechtEngineer
259315
answered Nov 12 '17 at 11:07
MechtEngineer
259315
answered Nov 12 '17 at 11:07
MechtEngineer
259315
answered Nov 12 '17 at 11:07
MechtEngineer
259315
259315
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%2f1066139%2fhow-to-link-cells-in-column-to-cell-in-rows%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
