In this video, I will show you how to select only the visible cells in Excel.
This may be required when you have some hidden rows/columns in Excel. When you have some hidden rows/column and you copy a range with these hidden rows/columns, Excel automatically copies them as well.
And if you only want to copy the visible cells, you first need to select these visible cells and then copy it.
There is a really simple keyboard shortcut that I show in the video that you can use to select visible cells only.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
this simply did not work
Thank you for the information got stuck in making mis , really helpful.
I agree with Miles 🙂 Short and to the point. This will have saved me hours of filtering thousands of rows that are divided into 5 regions/systems. The only problem I had (on Mac) was that I could not copy merged cells in the headers, so I ignored them and transfered the data without hassle – then the merged cell headers can be transferred without much issue.
Great video! Concise, no waffling – excellent!
Thank you for sharing your knowledge with us.
Below I have shared details like the Excel sheet, I need to insert the formula for filtered rows also, but it is not possible to get the same result.
Is there any formula or any trick to get the every 10 (Ex: 10, 100, 500, 2500, or 5000) rows the same repeated number like this. # A B C
1 Product Id Every 10th Row Same No Formula
2 95316586 1 INT((ROW(B2)-1)/10)+1
3 14008250 1 INT((ROW(B3)-1)/10)+1
4 51344786 1 INT((ROW(B4)-1)/10)+1
5 11564560 1 INT((ROW(B5)-1)/10)+1
6 90672105 1 INT((ROW(B6)-1)/10)+1
7 38951727 1 INT((ROW(B7)-1)/10)+1
8 31782715 1
9 68057986 1
10 73613927 2
11 59261066 2
12 99379070 2
13 49624137 2
14 38996910 2
15 22038957 2
16 24009973 2
17 19158543 2
18 93166423 2
19 43083752 2
20 65098014 3
21 28126129 3
22 37234830 3
23 50197572 3
24 92456682 3
25 56870745 3
Saves lot of time…..very good trick it is….thank you
Nothing is working with alt + semicolon . Pls give correct tricks ….and no dialog box appears with F5 . Pls check and help
It’s not working on big data which is having filter on it . Pls help
Hi Sumit – how do I define the visible area, and all else is white or not visible at all? I am creating a form to send to clients and I want the client to only be able to view a defined area. How is this done?
Thanks a lot. 👍
You can also copy and paste in notepad and copy from notepad to paste back to excel
Sumit Sir,
ये मैने पहले कभी नहीं पढ़ा, बहुत बहुत धन्यवाद! ; )
I’m liking and have subscribed.
These shorter videos of 2-3 minutes let me learn as well as save my time. Plz keep less than 3 minutes
Very helpful, and very informative. Thank you so much..
Excellent shortcut
At last, something i new already! I'm proud of myself now! 🙂 Thanks Sumit 🙂
Hi Sumit.. great tip. I've always used the shortcut ALT+; Thanks for showing how to get there with Go To Special; Visible Cells Only. Will remember that second method in the future. Thumbs up!
***Please teach us VBA concepts from Basic to Advance level. Waiting from long time.
Very useful Concept. Thanks a lot.
Good work
Thanks Sumit 👍
Dear sir,
Today you gave a solution to a very common error. Really useful.
Will it help for editing of visible cells only too, as it is also a serious problem. You will never know when your data get corrupted.