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:
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!