Thankyou very much for the tutorial. Copy pasting in excel is a mystery.
@AndyMahnFL411
3 жыл бұрын
Hoping that your mastery of it is just a little bit of practice away!
@FILIPINOAMERICANHEARTCHANNEL
2 жыл бұрын
andyMahn your my hero in applying for a job today. thank you i got an idea
@AndyMahnFL411
2 жыл бұрын
Did it work?
@lydiaotieno7592
2 жыл бұрын
Saved me so much, thanks to you.
@AndyMahnFL411
2 жыл бұрын
Sure thing, glad you found the video!
@muktaray8338
3 жыл бұрын
Nice presentation. Very very helpful to me. Thank you so much. 😊😊😊
@AndyMahnFL411
3 жыл бұрын
👍😊
@muktaray8338
3 жыл бұрын
@@AndyMahnFL411 😶
@muktaray8338
3 жыл бұрын
@@AndyMahnFL411 Thank you..... ☺☺☺☺
@dadon9537
3 жыл бұрын
kzitem.info/news/bejne/05uEnWqpsnxlrXo
@crookedlilsmile
5 ай бұрын
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!
@AndyMahnFL411
5 ай бұрын
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
5 ай бұрын
@@AndyMahnFL411 Thank you so much, I'll try that next time.
@AndyMahnFL411
5 ай бұрын
@@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
@crookedlilsmile
5 ай бұрын
@@AndyMahnFL411 Ohhhh, yeah. OK, tks.
@zahraghavidast365
9 ай бұрын
Thank you so much! Very helpful!
@AndyMahnFL411
9 ай бұрын
You're 100% welcome!
@imeldacabangon2277
4 жыл бұрын
Clear explanation, nice
@imeldacabangon2277
4 жыл бұрын
Thanks for that
@vkvajpai6183
4 жыл бұрын
Nice information Thank you so much
@AndyMahnFL411
4 жыл бұрын
Sure thing, happy to help.
@lydiaotieno7592
4 жыл бұрын
Thanks so much for your help....
@AndyMahnFL411
4 жыл бұрын
Happy to help!
@Sanket542
4 ай бұрын
Thank you ❤
@AndyMahnFL411
4 ай бұрын
You are welcome 😊
@MD-xl3lj
2 жыл бұрын
Thanks bruv
@UrbanCraftTv
Жыл бұрын
nice
@haroldpenales1454
2 жыл бұрын
Thank you
@AndyMahnFL411
2 жыл бұрын
👍🏼
@redredwine1277
5 жыл бұрын
Thanks 🎄
@AndyMahnFL411
5 жыл бұрын
😊
@GCA4truth
4 жыл бұрын
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.
@caspersbestfriend
4 жыл бұрын
I do this. But howcome I click and drag down it just rearanges the information?
@THEDReamER347
2 жыл бұрын
Thanqq
@chinetugoigboanusi8415
Жыл бұрын
How do I paste values only from clipboard?
@gtxgtx1903
Жыл бұрын
Why wont it copy/paste 1 on 1? I have to adjust all the rows widt all the time
@Brucee_97
2 жыл бұрын
2:20 esc to remove “escape border”
@subashmagdalin8445
3 жыл бұрын
Thank u nanba
@kristophermanansala4434
4 жыл бұрын
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.
@AndyMahnFL411
4 жыл бұрын
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.
@balajiupbhokta9074
5 жыл бұрын
thanks ☺
@AndyMahnFL411
5 жыл бұрын
You're quite welcome.
@tanyamccomas1110
2 жыл бұрын
How to deslect the cells you had already copied and pasted...it remains selected
@AndyMahnFL411
2 жыл бұрын
Hit the Esc key.
@munivenkatappag9157
5 жыл бұрын
Very gud info thanks a lot sir/ madam
@AndyMahnFL411
5 жыл бұрын
You're welcome, happy to have helped out.
@venkatsangeeth9851
3 жыл бұрын
Bro I have 600 lines so how can I copy them all
@AndyMahnFL411
3 жыл бұрын
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.
@venkatsangeeth9851
3 жыл бұрын
Thanks for the replay dude I thought you won't give replay bez the video was 4 years ago thanks bro
@elizabethvasquez1024
4 жыл бұрын
What if you want to copy to word or an email
@AndyMahnFL411
4 жыл бұрын
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.
@elizabethvasquez1024
4 жыл бұрын
Ok what if I want to keep the cells
@AndyMahnFL411
4 жыл бұрын
@@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.
Пікірлер: 58