Excel 2007 : paste from clipboard to visible rows only
What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
When I paste the information from the txt file into the sheet, it take into account the hidden lines... half of my data is trapped in the hidden lines.
I've tried the F5 manipulation to only select the visible cells (for the destination) and it's not working ("copied zones and pasted zones have different sizes").
microsoft-excel-2007
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
add a comment |
What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
When I paste the information from the txt file into the sheet, it take into account the hidden lines... half of my data is trapped in the hidden lines.
I've tried the F5 manipulation to only select the visible cells (for the destination) and it's not working ("copied zones and pasted zones have different sizes").
microsoft-excel-2007
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31
add a comment |
What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
When I paste the information from the txt file into the sheet, it take into account the hidden lines... half of my data is trapped in the hidden lines.
I've tried the F5 manipulation to only select the visible cells (for the destination) and it's not working ("copied zones and pasted zones have different sizes").
microsoft-excel-2007
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
When I paste the information from the txt file into the sheet, it take into account the hidden lines... half of my data is trapped in the hidden lines.
I've tried the F5 manipulation to only select the visible cells (for the destination) and it's not working ("copied zones and pasted zones have different sizes").
microsoft-excel-2007
microsoft-excel-2007
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
asked Aug 14 '14 at 9:00
Laurent W.Laurent W.
1012
1012
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31
add a comment |
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31
add a comment |
1 Answer
1
active
oldest
votes
This is probably not the proper way, but it works for me.
I paste the txt lines in to a new sheet or workbook of excel, starting from B1. In my filtered sheet showing only the visible data I select all cells in the column and press Alt+, to only select the visible ones.
I type in =ROW("cell to the left" ie: A7), and press Ctrl+Enter, to enter it across all cells. Then I copy them and paste them as values in the new sheet to the left of my data. It should only paste the visible ones.
Afterwards I go back to original sheet and edit the formula to be =VLOOKUP(ROW(A7),NEWSHEET!A:B,2,FALSE) to get my data from column B.
edited Dec 26 '18 at 19:48
mature
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
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%2f796871%2fexcel-2007-paste-from-clipboard-to-visible-rows-only%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
This is probably not the proper way, but it works for me.
I paste the txt lines in to a new sheet or workbook of excel, starting from B1. In my filtered sheet showing only the visible data I select all cells in the column and press Alt+, to only select the visible ones.
I type in =ROW("cell to the left" ie: A7), and press Ctrl+Enter, to enter it across all cells. Then I copy them and paste them as values in the new sheet to the left of my data. It should only paste the visible ones.
Afterwards I go back to original sheet and edit the formula to be =VLOOKUP(ROW(A7),NEWSHEET!A:B,2,FALSE) to get my data from column B.
edited Dec 26 '18 at 19:48
mature
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
add a comment |
This is probably not the proper way, but it works for me.
I paste the txt lines in to a new sheet or workbook of excel, starting from B1. In my filtered sheet showing only the visible data I select all cells in the column and press Alt+, to only select the visible ones.
I type in =ROW("cell to the left" ie: A7), and press Ctrl+Enter, to enter it across all cells. Then I copy them and paste them as values in the new sheet to the left of my data. It should only paste the visible ones.
Afterwards I go back to original sheet and edit the formula to be =VLOOKUP(ROW(A7),NEWSHEET!A:B,2,FALSE) to get my data from column B.
edited Dec 26 '18 at 19:48
mature
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
add a comment |
This is probably not the proper way, but it works for me.
I paste the txt lines in to a new sheet or workbook of excel, starting from B1. In my filtered sheet showing only the visible data I select all cells in the column and press Alt+, to only select the visible ones.
I type in =ROW("cell to the left" ie: A7), and press Ctrl+Enter, to enter it across all cells. Then I copy them and paste them as values in the new sheet to the left of my data. It should only paste the visible ones.
Afterwards I go back to original sheet and edit the formula to be =VLOOKUP(ROW(A7),NEWSHEET!A:B,2,FALSE) to get my data from column B.
edited Dec 26 '18 at 19:48
mature
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
This is probably not the proper way, but it works for me.
I paste the txt lines in to a new sheet or workbook of excel, starting from B1. In my filtered sheet showing only the visible data I select all cells in the column and press Alt+, to only select the visible ones.
I type in =ROW("cell to the left" ie: A7), and press Ctrl+Enter, to enter it across all cells. Then I copy them and paste them as values in the new sheet to the left of my data. It should only paste the visible ones.
Afterwards I go back to original sheet and edit the formula to be =VLOOKUP(ROW(A7),NEWSHEET!A:B,2,FALSE) to get my data from column B.
edited Dec 26 '18 at 19:48
mature
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
edited Dec 26 '18 at 19:48
mature
1474
edited Dec 26 '18 at 19:48
mature
1474
edited Dec 26 '18 at 19:48
mature
1474
1474
answered Dec 16 '18 at 14:46
user218076user218076
1508
answered Dec 16 '18 at 14:46
user218076user218076
1508
answered Dec 16 '18 at 14:46
user218076user218076
1508
1508
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%2f796871%2fexcel-2007-paste-from-clipboard-to-visible-rows-only%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
Did you ever figure out how to do this? I'm having trouble with this as well.
– sigil
Oct 10 '14 at 16:53
Unfortunately... No.
– Laurent W.
Oct 13 '14 at 7:31