Easy Shortcuts to Copy Visible Cells Only in Excel
Рет қаралды 4,144
Күн бұрынIn this short video, I will show you how to quickly select only the visible cells in a data set in Excel (while not selecting the hidden cells).
There's an easy shot cut in Excel to only select visible cells in Excel, and once you have selected them, you can easily copy them using regular Control + C
00:00 Intro
00:08 Keyboard Shortcut to Copy Visible Cells
00:59 Go To Special dialog box to Select and Copy Visible Cells
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
@meetkcs 3 ай бұрын
Point Blank Content - No unnecessary lagging - Straight to the point !!. - Thank you for - Informative Content- Highly Appreciated Your Efforts.
@nasserpokie 4 ай бұрын
Always simple/Clear/Easily understandable and informative content is the symbol of mr sumit Thanks again and again
@trumpexcel 4 ай бұрын
Thanks for the kind words 🙂 Glad you found the video helpful
@fuada4673 4 ай бұрын
Your video simple and useful Thanks a lot شكرا كثيرا لك
@trumpexcel 4 ай бұрын
Glad you found the video helpful 🙂
@derekporter66 4 ай бұрын
Very good. Please do more shortcuts like this
@trumpexcel 4 ай бұрын
Sure.. will make more like these
@IvanCortinas_ES 4 ай бұрын
Excelent trick. Thank you for sharing, Sumit.
@dpk000sharma 4 ай бұрын
Hi, Sumit. Can you make a Stock Trading Journal Dashboard and teach us. Currently, I am watching your Excel Dashboard Series. 👍
@nadermounir8228 4 ай бұрын
Thank you Summit for this informative video 📹 👍
@trumpexcel 4 ай бұрын
Thanks for commenting Nader... Glad you found the video helpful 🙂
@trumpexcel 4 ай бұрын
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
@dpk000sharma 4 ай бұрын
You can PIN this comment.
@abidejaz1090 4 ай бұрын
Nice 😊
@syedikramullah1114 4 ай бұрын
Nice
@PankajSharma-hx2mv 4 ай бұрын
I don't know how your channel very underrated 😢
@sjh3099 4 ай бұрын
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
@trumpexcel 4 ай бұрын
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
@sekharispassion 4 ай бұрын
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.
@trumpexcel 4 ай бұрын
Have a look at this - kzfaq.info/get/bejne/abGbnduqnci3qI0.html