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
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
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
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.
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
.
add a comment |Â
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
.
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
.
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
.
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 yesterday
mature
1494
1494
answered Dec 16 at 14:46
user218076
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.
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%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