If I want be able to copy down a column without copying over the hidden rows. Example. Let’s say 0:32 column B “department” also had the department called sales (hidden). So now I copy marketing all way down the column. But I don’t want rows with term sales copied over by marketing. How do I do this? Thank you for your lovely videos. Salaams. 0:32
If it's just one value you want to copy, you can copy and paste it in filtered cells and it should work. If you're manually entering, you can use ALT + semicolon to select only visible cells and then enter the value in the active cell and the use Control + Enter. I will be posting a video about this next week
Sir, is there any way to copy cells that are filtered and paste in other sheet which is also filtered. I have tried but excel displays message the copied and paste area differs. Then I use index and match function to get the values. Thank you for the video. I use Ctrl +G, Alt+S and Y to copy visible cells.
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
Point Blank Content - No unnecessary lagging - Straight to the point !!. - Thank you for - Informative Content- Highly Appreciated Your Efforts.
Always simple/Clear/Easily understandable and informative content is the symbol of mr sumit Thanks again and again
Thanks for the kind words 🙂 Glad you found the video helpful
Very good. Please do more shortcuts like this
Sure.. will make more like these
Excelent trick. Thank you for sharing, Sumit.
Thank you Summit for this informative video 📹 👍
Thanks for commenting Nader... Glad you found the video helpful 🙂
Hi, Sumit. Can you make a Stock Trading Journal Dashboard and teach us.
Currently, I am watching your Excel Dashboard Series. 👍
Your video simple and useful
Thanks a lot
شكرا كثيرا لك
Glad you found the video helpful 🙂
Nice
I don't know how your channel very underrated 😢
Nice 😊
If I want be able to copy down a column without copying over the hidden rows. Example. Let’s say 0:32 column B “department” also had the department called sales (hidden). So now I copy marketing all way down the column. But I don’t want rows with term sales copied over by marketing. How do I do this?
Thank you for your lovely videos. Salaams. 0:32
If it's just one value you want to copy, you can copy and paste it in filtered cells and it should work. If you're manually entering, you can use ALT + semicolon to select only visible cells and then enter the value in the active cell and the use Control + Enter. I will be posting a video about this next week
Sir, is there any way to copy cells that are filtered and paste in other sheet which is also filtered.
I have tried but excel displays message the copied and paste area differs. Then I use index and match function to get the values.
Thank you for the video. I use Ctrl +G, Alt+S and Y to copy visible cells.
Have a look at this - czcams.com/video/3Kkjxy8bSxY/video.html
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
You can PIN this comment.