How To PASTE into VISIBLE CELLS ONLY When You Have HIDDEN Rows/Cells In MS Excel

How To PASTE into VISIBLE CELLS ONLY When You Have HIDDEN Rows or Cells In Excel

#excel
#copypaste
#exceltutorial

Below is the link to my previous video on the same topic in which I used the Skip Blanks feature instead:

[ritikjain]

This is a video which has solved an exact problem to the point which is almost no where else discussed over Internet., Thank you

[jonthoppil]

more than anything else, i liked your sticking to your promise to someone in the other video. I was looking for this, and ended up in the previous video. Read the comment, and then i saw a link to this video. Awesome job. Very useful video. THNAK YOU !!

[PatriciaMassengill]

Thank you! You are the only one that has information on how to paste into visible cells only! Thank you!

[Mcfine]

Thanks for the video. This answers my question on your other video :). Gosh how much I have been looking for this solution :)

[emilieguillon]

Hi thanks for this video. How do you do if you want to paste ABCD and not ABGH in the lines 3-4-9-10 ? Is it doable ? Thanks in advance for your answer.

[MichelleCrecelius]

When I followed these instructions, all my cells that I wanted to got filled but only with the first cell that I selected from my copy column. It was in a different Excel file but I didn't think that would matter. I'm not sure what I'm doing wrong.

[shoppersdream]

Thanks! My scenario is a little more complicated than one Column Only. I have 10 Columns which I get every day when I run the report. Let us say A, B, C, D, E, F, G, H, I, J Now I tried to add columns E and H in a separate table template and I created one column Let us say in 'I' I use a formula =SUM (E2+H2) in the middle so all the columns after that move one place to the right. Now how do I paste to all cells except Column "I" since I want that Formula to do its job based on the new values I pasted. I can do it in a couple of steps but I was looking for a better way. Thanks

[Mcfine]

What do I do please if the number of visible cells is the same as the one I am copying from? When I do this it only takes the fist value. I am trying to copy one range from one sheet and paste it into another sheet within specific visible ceĺls.

[dhirajkanrajjain]

Finally you presentation only worked for me.. subscribing to your channel now..

[ramu]

Thankyou Louis for asking the question, I'm facing the exact problem now

[raymondlew]

but row 9 and 10 i would like my result to be C and D . can this be done ?

[Vincent-ricr]

Hello sir. How do I make it so that the hidden rows won't get filled in, but that the following visible rows get the continued data instead of skipping the middle part? E.g. in your example; you paste AB & GH in 1, 2 and 7, 8. How do I make it such that I can paste AB & CD in columns 1, 2 and 7, 8? Do you understand my problem?

I got an an excel sheet with an insane amount of data and I can not remove individual rows between my data so that they match my other excel sheet (that contains hidden rows).

Thank you

[newthings]

thanks for the video but it gives me 0s if I have blanks in the data set i wanted to copy it from and pastes only half of the total data. Is there a way to simply paste anything from the copied data set to the visible rows/cells?

[ritikjain]

But how about removing the formula =C15 that has been pasted over the cells, only retain the values pasted?

[jaysonmariano]

what if you wanted to do this for copy and paste it to another sheet?

[SureshKumar-xsvt]

I have two different sheets with multiple cells of data ..in both sheets data was hided ..now the question is from 1st sheet to 2nd sheet only visible cells want paste...how its possible

[realmehranvahedi]

I appreciate your engagement and questions in the comments section! To make it fun, I'll pin the most popular comment! So, give a thumbs up to the comment you like the most, and let's see who takes the top spot!


I appreciate each and every one of you & Thank You for your continued support!

Best regards,
Mehran Vahedi

[MountainRat]

You spent 4 minutes just explaining the title. I clicked on this because obviously i know what I am looking for.