Easy Shortcuts to Copy Visible Cells Only in Excel
HTML-код
- Опубликовано: 29 июн 2024
- 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: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
Point Blank Content - No unnecessary lagging - Straight to the point !!. - Thank you for - Informative Content- Highly Appreciated Your Efforts.
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.
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.
Your video simple and useful
Thanks a lot
شكرا كثيرا لك
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. 👍
Thank you Summit for this informative video 📹 👍
Thanks for commenting Nader... Glad you found the video helpful 🙂
I don't know how your channel very underrated 😢
Nice 😊
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 - ruclips.net/video/3Kkjxy8bSxY/видео.html