Hello, thank you. How do you paste into a sheet in-between rows without having new information delete /replace previous row. I only know how to add more blank rows to create the space to copy paste, but think there should be an easier way for larger group rows to copy/paste Thanks!
If you copy the selection of rows which you want to paste into an existing data sheet, you can right click the row above which you like the new data to go (right click on the row number), you will have the option to insert your copied cells above the selection.
@@crookedlilsmile you can also simply add the new rows of copied data to the end and then use filtering or sorting to integrate with your existing data records
I am making a to-do list with checkboxes. After checking off a task how could I: move it to an accomplished list, on the same sheet, delete the checked accomplished from the original list without altering the newly added data to the accomplished list? Can this be done using dynamic arrays, VBA or advanced filters? If so, how? Thank you for your consideration.
Please help me I wanna paste my selected column to a filtered column. For example: i Have a column that has different kinds of names and i want it to be paste beside my filtered column so that each side corresponds to the name and if I unfiltered it, I want it to fit to their specific cells. Another example: i have a yellow marked cells and if i filtered out all the yellow cells, i want the names to be paste beside that filtered yellow mark so each yellow mark fits to their specific names. It is not appearing completly every time I paste it beside the filtered section.The names wont come out completly or it appears half of the names i copied and if i unfiltered it the names are completly scattered inside the column and the names wont match to the cells or column that i wanted it to be. Please help me it will save me a lot of time and work. I'm copying and pasting it manually for more than a thousand cells everyday and it is really time consuming and it is hurting my hands so bad. Thanks in advance i hope you guys can help me! Sorry for my english I really cant explain it well.
You may need to use a Go To Special option. Ctrl + G will present this dialog along with the selections. It gives the option to work with the 'Visible cells only' which you may want to do when working with filtered data. I certainly hope this helps move you in the right direction.
Just highlight or select the portion that you'd like to copy, and then either use the menus or the keyboard keystrokes, ctrl-c will copy, ctrl-v will paste. Use these options in your Word or email, once you've copied or selected the content you want from Excel.
Highlight all the rows that you need, then use the copy and paste function to copy them and paste them into the destination that you want. You can also right click the tab of your sheet and create a copy of that sheet, if that would help.
Thankyou very much for the tutorial.
Copy pasting in excel is a mystery.
Hoping that your mastery of it is just a little bit of practice away!
Saved me so much, thanks to you.
Sure thing, glad you found the video!
andyMahn your my hero in applying for a job today. thank you i got an idea
Did it work?
Thank you so much! Very helpful!
You're 100% welcome!
Nice presentation. Very very helpful to me. Thank you so much. 😊😊😊
👍😊
@@AndyMahnFL411 😶
@@AndyMahnFL411 Thank you..... ☺☺☺☺
ua-cam.com/video/reN76syJ4zE/v-deo.html
Thank you ❤
You are welcome 😊
Hello, thank you. How do you paste into a sheet in-between rows without having new information delete /replace previous row. I only know how to add more blank rows to create the space to copy paste, but think there should be an easier way for larger group rows to copy/paste Thanks!
If you copy the selection of rows which you want to paste into an existing data sheet, you can right click the row above which you like the new data to go (right click on the row number), you will have the option to insert your copied cells above the selection.
@@AndyMahnFL411 Thank you so much, I'll try that next time.
@@crookedlilsmile you can also simply add the new rows of copied data to the end and then use filtering or sorting to integrate with your existing data records
@@AndyMahnFL411 Ohhhh, yeah. OK, tks.
Clear explanation, nice
Thanks for that
Nice information
Thank you so much
Sure thing, happy to help.
Thanks so much for your help....
Happy to help!
I do this. But howcome I click and drag down it just rearanges the information?
I am making a to-do list with checkboxes. After checking off a task how could I: move it to an accomplished list, on the same sheet, delete the checked accomplished from the original list without altering the newly added data to the accomplished list? Can this be done using dynamic arrays, VBA or advanced filters? If so, how? Thank you for your consideration.
How do I paste values only from clipboard?
2:20 esc to remove “escape border”
Thanks bruv
Why wont it copy/paste 1 on 1? I have to adjust all the rows widt all the time
Thanks 🎄
😊
Thank you
👍🏼
nice
How to deslect the cells you had already copied and pasted...it remains selected
Hit the Esc key.
Please help me I wanna paste my selected column to a filtered column. For example: i Have a column that has different kinds of names and i want it to be paste beside my filtered column so that each side corresponds to the name and if I unfiltered it, I want it to fit to their specific cells. Another example: i have a yellow marked cells and if i filtered out all the yellow cells, i want the names to be paste beside that filtered yellow mark so each yellow mark fits to their specific names.
It is not appearing completly every time I paste it beside the filtered section.The names wont come out completly or it appears half of the names i copied and if i unfiltered it the names are completly scattered inside the column and the names wont match to the cells or column that i wanted it to be. Please help me it will save me a lot of time and work.
I'm copying and pasting it manually for more than a thousand cells everyday and it is really time consuming and it is hurting my hands so bad.
Thanks in advance i hope you guys can help me! Sorry for my english I really cant explain it well.
You may need to use a Go To Special option. Ctrl + G will present this dialog along with the selections. It gives the option to work with the 'Visible cells only' which you may want to do when working with filtered data. I certainly hope this helps move you in the right direction.
Very gud info thanks a lot sir/ madam
You're welcome, happy to have helped out.
Thank u nanba
What if you want to copy to word or an email
Just highlight or select the portion that you'd like to copy, and then either use the menus or the keyboard keystrokes, ctrl-c will copy, ctrl-v will paste. Use these options in your Word or email, once you've copied or selected the content you want from Excel.
Ok what if I want to keep the cells
@@elizabethvasquez1024 they are there, you just need to make the borders visible. When it copies, it's copying it in the form of a table.
Bro I have 600 lines so how can I copy them all
Highlight all the rows that you need, then use the copy and paste function to copy them and paste them into the destination that you want. You can also right click the tab of your sheet and create a copy of that sheet, if that would help.
Thanks for the replay dude I thought you won't give replay bez the video was 4 years ago thanks bro
thanks ☺
You're quite welcome.
Thanqq
Ok
.... thanks
0