Paste link into Table disallowed?
I am trying to use the Copy / Paste Link (ALT+ESL), but it does not appear to be an option when pasting into a Table.
Is this a known limitation of Excel (using 2013)? If so, is there a better work around than doing the Paste Link outside of the Table and then Cut / Paste into the Table?
Paste Link is missing in the Table
Same cell is available to paste link outside Table (far right icon)
I did a search here on SuperUser but was unable to find a direct match. This question is similar but is more about linking to an entire Table and not pasting into a Table.
microsoft-excel microsoft-excel-2013 copy-paste cut-and-paste
edited Mar 20 '17 at 10:16
Community♦
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
add a comment |
I am trying to use the Copy / Paste Link (ALT+ESL), but it does not appear to be an option when pasting into a Table.
Is this a known limitation of Excel (using 2013)? If so, is there a better work around than doing the Paste Link outside of the Table and then Cut / Paste into the Table?
Paste Link is missing in the Table
Same cell is available to paste link outside Table (far right icon)
I did a search here on SuperUser but was unable to find a direct match. This question is similar but is more about linking to an entire Table and not pasting into a Table.
microsoft-excel microsoft-excel-2013 copy-paste cut-and-paste
edited Mar 20 '17 at 10:16
Community♦
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
add a comment |
I am trying to use the Copy / Paste Link (ALT+ESL), but it does not appear to be an option when pasting into a Table.
Is this a known limitation of Excel (using 2013)? If so, is there a better work around than doing the Paste Link outside of the Table and then Cut / Paste into the Table?
Paste Link is missing in the Table
Same cell is available to paste link outside Table (far right icon)
I did a search here on SuperUser but was unable to find a direct match. This question is similar but is more about linking to an entire Table and not pasting into a Table.
microsoft-excel microsoft-excel-2013 copy-paste cut-and-paste
edited Mar 20 '17 at 10:16
Community♦
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
I am trying to use the Copy / Paste Link (ALT+ESL), but it does not appear to be an option when pasting into a Table.
Is this a known limitation of Excel (using 2013)? If so, is there a better work around than doing the Paste Link outside of the Table and then Cut / Paste into the Table?
Paste Link is missing in the Table
Same cell is available to paste link outside Table (far right icon)
I did a search here on SuperUser but was unable to find a direct match. This question is similar but is more about linking to an entire Table and not pasting into a Table.
microsoft-excel microsoft-excel-2013 copy-paste cut-and-paste
microsoft-excel microsoft-excel-2013 copy-paste cut-and-paste
edited Mar 20 '17 at 10:16
Community♦
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
edited Mar 20 '17 at 10:16
Community♦
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
edited Mar 20 '17 at 10:16
Community♦
1
edited Mar 20 '17 at 10:16
Community♦
1
edited Mar 20 '17 at 10:16
Community♦
1
1
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
asked May 14 '15 at 21:58
Byron WallByron Wall
462311
462311
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
what i did after nearly punching myself in the face in frustration, ='Data List'!A3 .
data list is my sheet name.
but then i wanted it to update constantly and data list holds a table and i can't table, so i dragged the formula down a row of boxes so that they'd match even if data list got updated.
if you do the same, you'll realise that the empty boxes in data list gives you a 0 with the formula.
so i did this =IF(ISBLANK('Data List'!A3),"",'Data List'!A3)
interpretation: if data list box a3 is empty, don't give me anything. if it's not, give me what data list a3 has.
not very savvy, but this is what i did with my noob excel skills.
answered Jun 25 '15 at 3:10
claudiaclaudia
1
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%2f914974%2fpaste-link-into-table-disallowed%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
what i did after nearly punching myself in the face in frustration, ='Data List'!A3 .
data list is my sheet name.
but then i wanted it to update constantly and data list holds a table and i can't table, so i dragged the formula down a row of boxes so that they'd match even if data list got updated.
if you do the same, you'll realise that the empty boxes in data list gives you a 0 with the formula.
so i did this =IF(ISBLANK('Data List'!A3),"",'Data List'!A3)
interpretation: if data list box a3 is empty, don't give me anything. if it's not, give me what data list a3 has.
not very savvy, but this is what i did with my noob excel skills.
answered Jun 25 '15 at 3:10
claudiaclaudia
1
add a comment |
what i did after nearly punching myself in the face in frustration, ='Data List'!A3 .
data list is my sheet name.
but then i wanted it to update constantly and data list holds a table and i can't table, so i dragged the formula down a row of boxes so that they'd match even if data list got updated.
if you do the same, you'll realise that the empty boxes in data list gives you a 0 with the formula.
so i did this =IF(ISBLANK('Data List'!A3),"",'Data List'!A3)
interpretation: if data list box a3 is empty, don't give me anything. if it's not, give me what data list a3 has.
not very savvy, but this is what i did with my noob excel skills.
answered Jun 25 '15 at 3:10
claudiaclaudia
1
add a comment |
what i did after nearly punching myself in the face in frustration, ='Data List'!A3 .
data list is my sheet name.
but then i wanted it to update constantly and data list holds a table and i can't table, so i dragged the formula down a row of boxes so that they'd match even if data list got updated.
if you do the same, you'll realise that the empty boxes in data list gives you a 0 with the formula.
so i did this =IF(ISBLANK('Data List'!A3),"",'Data List'!A3)
interpretation: if data list box a3 is empty, don't give me anything. if it's not, give me what data list a3 has.
not very savvy, but this is what i did with my noob excel skills.
answered Jun 25 '15 at 3:10
claudiaclaudia
1
what i did after nearly punching myself in the face in frustration, ='Data List'!A3 .
data list is my sheet name.
but then i wanted it to update constantly and data list holds a table and i can't table, so i dragged the formula down a row of boxes so that they'd match even if data list got updated.
if you do the same, you'll realise that the empty boxes in data list gives you a 0 with the formula.
so i did this =IF(ISBLANK('Data List'!A3),"",'Data List'!A3)
interpretation: if data list box a3 is empty, don't give me anything. if it's not, give me what data list a3 has.
not very savvy, but this is what i did with my noob excel skills.
answered Jun 25 '15 at 3:10
claudiaclaudia
1
answered Jun 25 '15 at 3:10
claudiaclaudia
1
answered Jun 25 '15 at 3:10
claudiaclaudia
1
answered Jun 25 '15 at 3:10
claudiaclaudia
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%2f914974%2fpaste-link-into-table-disallowed%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
