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

[@realmehranvahedi]

🚀 Exciting update! If you're looking to streamline your Excel tasks even further, check out my new video on automating the 'Paste into Visible Cells Only' process using VBA. It's a great way to enhance your skills and save time! Watch it here: kzbin.info/www/bejne/gqbSc4mPetOEfdE. Enjoy and let me know what you think!

[@ritikjain3311]

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

[@matttzzz2]

Ive never experienced this issue until today. For years I've been able to paste into cells without affecting the hidden ones, now suddenly today that doesn't work anymore!

[@jonthoppil8739]

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 !!

[@realmehranvahedi]

Glad I could help

[@Mcfine2011]

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

[@realmehranvahedi]

You're very welcome! I'm thrilled to hear that the video provided the solution you were seeking. Your enthusiasm and quest for answers are exactly what motivates me to keep creating content. If you have any more questions or there's another topic you're curious about, feel free to let me know. I'm here to help. Thanks for watching and for your kind feedback! 😊

[@emilieguillon30]

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.

[@realmehranvahedi]

Hello @emilieguillon30, Thank you so much for your question and for watching the video! To specifically address your query about pasting "ABCD" instead of "ABGH" in specific lines, I recommend checking out these videos where I cover the exact topic you're interested in. These videos indeed provide the tips and steps you need: Video 1: kzbin.info/www/bejne/a5DRm6J3i62krsksi=BZNdNTiqlrbOW8an Video 2: kzbin.info/www/bejne/nnSUc4Rrj9h-jdksi=4KKuXgcIepJTNA2J Video 3: kzbin.info/www/bejne/gqbSc4mPetOEfdEsi=4H8lepmhg7XDzoNz I'm confident these will address the issue you’re facing. Please keep the comments coming and feel free to ask any more questions you might have. Your engagement is invaluable and inspires me to continue providing helpful content! Cheers, Mehran

[@newthings5648]

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?

[@orleingalo5675]

This is very useful. Thank you.

[@realmehranvahedi]

Hi Orlien, thanks for leaving a comment. I am happy that you found the video useful 😀

[@Vincent-ri5cr]

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

[@realmehranvahedi]

Hello Vincent, thank you very much for the interesting question. In order to achieve that you can do two things. The first approach is to highlight the visible cells which you want to paste into and then sort by color and then copy & paste from the source range into the destination range. The second approach is to use the fill feature in the Home tab within the ribbon but all the data must be stored in the same row for this approach to work. I will create another video to explain this in detail. Thanks again for the comment! Feel free to post any other questions or comments you have.

[@hizkiaal7299]

is the video already published@@realmehranvahedi ?

[@realmehranvahedi]

@@hizkiaal7299 Hello and thanks for the comment. Not yet. I will publish this soon. I will let you know once I do. Thanks for your patience.

[@realmehranvahedi]

Hi @Vincent-ri5cr, As promised, I created this new video to answer your question. In this video I clearly explain how to achieve what you had asked for. I hope you find it useful. Thanks again for the comment and for the great question and feel free to post any other questions you may have. kzbin.info/www/bejne/nnSUc4Rrj9h-jdk

[@realmehranvahedi]

Hello @@hizkiaal7299 , As promised, here is the link to the new video I just published on this topic : kzbin.info/www/bejne/nnSUc4Rrj9h-jdk

[@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

[@realmehranvahedi]

Hi @shoppersdream, Thanks for sharing your scenario! It sounds like you have a complex setup, but I can help streamline the process. Since you want to paste into all columns except for column 'I' where your formula resides, you can use the 'Paste Special' feature to selectively paste into only the visible cells of specific columns. Here’s a quick way to do it: 1. Select the range of cells you want to copy. 2. Go to the column or columns where you want to paste the data. Make sure to avoid selecting column 'I'. 3. Right-click on the selected area, choose ‘Paste Special’, and then select ‘Skip Blanks’. This option will paste the copied values into the visible cells without overwriting the formula in column 'I'. Alternatively, if you often need to repeat this process with similar ranges, consider creating a macro to automate these steps, which can save you even more time. I hope this helps! Let me know if you have any more questions or if there’s anything else I can assist you with. Happy Excel-ing!

[@jaysonmariano6648]

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

[@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.

[@realmehranvahedi]

Hi @MichelleCrecelius , Thanks for reaching out with your question. It sounds like you might be experiencing an issue with how Excel handles the 'Paste Special' function when dealing with data copied from another file. Make sure that after you select "Visible cells only" using the "Go To Special" dialog, you're copying the cells you want to paste into. Sometimes, Excel can default to pasting only the first copied cell across all selected visible cells if not done correctly. Also, I recommend checking out my latest videos on this very same topic for more tips and detailed steps that might help resolve your issue: Video 1: kzbin.info/www/bejne/a5DRm6J3i62krsksi=BZNdNTiqlrbOW8an Video 2: kzbin.info/www/bejne/nnSUc4Rrj9h-jdksi=4KKuXgcIepJTNA2J Video 3: kzbin.info/www/bejne/gqbSc4mPetOEfdEsi=4H8lepmhg7XDzoNz These should give you more insight and possibly address the issue you're facing. Feel free to post any further questions you might have! Cheers, Mehran

[@ramu992]

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

[@raymondlew7]

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

[@realmehranvahedi]

Hello @raymondlew7 , I invite you to watch my most recent video on this same topic. I think it will answer your question. you can watch it via the link below. If you have any more questions after watching, please don't hesitate to ask! kzbin.info/www/bejne/gqbSc4mPetOEfdE

[@Mcfine2011]

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.

[@realmehranvahedi]

Hi @Mcfine2011, thanks for your question! If the number of visible cells matches the range you're copying from, but it's only pasting the first value, make sure you're using the "Fill Visible Cells" method in Excel properly. Here’s what you can do: [1] First, copy the range you want from your source sheet. [2] Then, go to the destination sheet and select the range of visible cells you want to paste into. [3] Use the shortcut Alt + ; (semicolon) to ensure only visible cells are selected. [4] Finally, paste the values using Ctrl + V. This should paste into each visible cell rather than repeating the first value. If this doesn’t work, you might need to use a more specific VBA macro to handle complex scenarios where standard pasting doesn’t behave as expected. I hope this helps! Let me know if you have any more questions.

[@Mcfine2011]

Thank you for replying. Unfortunately it still didn't work. It says I can't paste because copy and paste area aren't the same size. Although the visible cells are same size as the ones I copied. But I guess it considers all the hidden cells. And when I apply the one of the video it paste the first value on all cells.

[@realmehranvahedi]

​@@Mcfine2011 Thank you for your feedback. It appears that the issue might be more complex due to the hidden cells being considered in the range. One approach to overcome this is by using a simple VBA macro that will only copy data into visible cells. Here’s a basic example of how you could set up such a macro assuming you want to copy from Sheet1 into hidden cells in sheet2: Sub CopyToVisibleCells() Dim sourceRange As Range Dim destRange As Range Dim cell As Range Dim i As Integer ' Define your source and destination ranges Set sourceRange = Sheets("Sheet1").Range("A2:A15") Set destRange = Sheets("Sheet2").Range("B2:B15") i = 1 For Each cell In destRange If cell.EntireRow.Hidden = False And cell.EntireColumn.Hidden = False Then cell.Value = sourceRange.Cells(i).Value i = i + 1 End If If i > sourceRange.Cells.Count Then Exit For Next cell End Sub This script will copy values from a specified range in Sheet1 to a matching range in Sheet2, but only into cells that are not hidden. Make sure to adjust "Sheet1" and "Sheet2" to the actual names of your sheets, and "A2:A15" and "B2:B15" to your specific ranges. To run this script, paste it into the VBA editor (you can access this by pressing ALT + F11 in Excel), and then run the macro. Ensure that macros are enabled in your Excel settings. Please let me know if this works for you or if there's anything else I can assist you with! Along with the VBA macro solution provided, I'm also planning to create a new video tutorial that will walk you through this process step-by-step. This video will help clarify how to implement the macro, ensuring you can effectively manage similar situations in the future. The video will cover everything from entering the macro into Excel to running it and checking the results. I'll let you know as soon as the video is uploaded. I hope this additional resource will make it even easier to resolve your Excel issues! Please stay tuned, and feel free to reach out if you have any further questions in the meantime.

[@realmehranvahedi]

@Mcfine2011 I just wanted to let you know that I've created a video tutorial in response to your question about pasting into visible cells only in Excel. You can find the video here: kzbin.info/www/bejne/gqbSc4mPetOEfdE This tutorial guides you through using a VBA macro to ensure data only goes into visible cells, which directly addresses the complexities you mentioned with hidden cells. It covers everything from how to enter the macro into Excel to running it and checking the results. Thank you for inspiring this video! Your questions help create useful content for everyone, and I appreciate your active involvement. Feel free to ask more questions-they are a great inspiration for new videos!

[@dhirajkanrajjain8947]

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

[@realmehranvahedi]

Hello, thank you for the comment. I am happy that you found the video useful. I invite you to also watch my latest video on the same topic : kzbin.info/www/bejne/nnSUc4Rrj9h-jdk

[@muafiatabasam5654]

you saved me sir ! thanks a lot

[@realmehranvahedi]

Hello Muafia, thanks for the comment. I am so happy to hear that you found the video useful. If you haven't already don't forget to like, share, and also subscribe and turn on notifications so you wont miss out on my future Excel tutorials. Thanks again for the comment🙂

[@muafiatabasam5654]

@@realmehranvahedi NO I realize now my happiness is temporaray, its skipping blanks but also skipping data that neeeded to be pasted.

[@muafiatabasam5654]

can you plz help?

[@muafiatabasam5654]

i have data that has a lot of blanks rows , i need to paste a data from other souce that dont have blanks, while searching i found your video ,its working but its skipping the data for blanks.

[@fatemehsamimi2205]

Thanks for the grt video

[@realmehranvahedi]

Thanks for the comment. I'm happy that you found it useful!

[@ritikjain3311]

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

[@realmehranvahedi]

Hello and thank you for the comment. If you want to remove the formula you can simply copy the data from that range and then do a paste as values after you have performed all the steps mentioned in the video. That is the simplest solution I can think of. I invite you to also watch my latest video on this topic. kzbin.info/www/bejne/nnSUc4Rrj9h-jdk Thanks again for the comment!

[@realmehranvahedi]

Dear viewers, I invite you to watch my new video on this same topic as it will provide answers to many of the questions asked in the comments section : kzbin.info/www/bejne/nnSUc4Rrj9h-jdk 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! Please note that while I will do my best to respond to as many comments as possible, I can only provide brief answers to generic questions in the comments section. For more in-depth or personalized assistance, I offer paid consultations. If you have specific or detailed questions that require more time and attention, feel free to book a personalized consultation with me via the following URL : topmate.io/mehran_vahedi I appreciate each and every one of you & Thank You for your continued support! Best regards, Mehran Vahedi

[@shnyxx]

How to past to a filtered table cells from a google sheet?

[@realmehranvahedi]

Hi @shnyxx, Thank you for watching the video! To paste data from a Google Sheet into a filtered table in Excel, start by selecting the data you want to copy from Google Sheets. Right-click and choose "Copy" or press Ctrl+C. Next, prepare your filtered table in Excel to show only the rows where you want to paste the data. Select the visible cells where you want to paste the data. Then, right-click and choose "Paste Special" or use the keyboard shortcut Ctrl+Alt+V. In the Paste Special dialog, select "Values" and click "OK". This method should allow you to paste data from Google Sheets into the visible cells of a filtered table in Excel. I hope this helps! If you have any further questions, feel free to ask. Best regards, Mehran

[@shnyxx]

​@@realmehranvahediThanks for the quick reply. Unfortunately, the method is not working​

[@realmehranvahedi]

Hi @shnyxx, Thank you for your feedback, and I'm sorry to hear that the method didn't work as expected. Since I specialize in Excel, the instructions provided are tailored specifically for Excel environments, and there may be some differences when applying them to Google Sheets. To troubleshoot, ensure that the data from Google Sheets is copied correctly and that your Excel table filters are set up properly to show only the rows where you want to paste the data. Sometimes, ensuring that you're pasting into the visible cells only can be tricky. Try using the "Alt + ;" shortcut in Excel to select visible cells before pasting. For Excel-specific assistance or any further queries related to Excel, feel free to reach out. Best regards, Mehran

[@SureshKumar-xs3vt]

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

[@PatriciaMassengill]

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

[@realmehranvahedi]

Hi @PatriciaMassengill, I'm so glad that you found the video useful! Thank you for your kind words. If you have any ideas for future topics or want to share more feedback, I’d love to hear from you!

[@RafaelSouza]

I was expecting ABCD

[@adamrindler5629]

yeah this is still pretty useless

[@realmehranvahedi]

Hello, thanks for the comment. Many other people have also had the same comment so I have created another video on how to paste only A,B,C and D into the visible cells. Please watch it and let me know if you have any questions : kzbin.info/www/bejne/nnSUc4Rrj9h-jdk

[@realmehranvahedi]

Hello@@adamrindler5629 , Hello, thanks for the comment. Many other people have also had the same comment so I have created another video on how to paste only A,B,C and D into the visible cells. Please watch it and let me know if you have any questions : kzbin.info/www/bejne/nnSUc4Rrj9h-jdk

[@MountainRat]

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

[@realmehranvahedi]

Thank you for your feedback! I appreciate you pointing out any repetitiveness in the video. I'll definitely keep this in mind and aim to be more concise in future videos. By the way, did you find the answer to your question in the video? Please let me know if there's anything specific you were looking for or if you have any other questions. Thanks again for watching and for your comment!

[@Xanxan0]

it didnt work.

[@realmehranvahedi]

Hello and thanks for the comment. When you try what happens? Perhaps consider watching my other video on this topic. It might help solve your issue: kzbin.info/www/bejne/a5DRm6J3i62krsksi=o5jZaCrXj-y4zXu0