How to Select Only the Visible Cells in Excel (SHORTCUT)

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:

#Excel #ExcelTips #Excelin2Minutes

select visible cells in excel,select visible cells shortcut,select visible cells only command,select visible cells copy and paste,copy visible cells only excel 2016,copy visible cells and paste values only to visible target cells,copy visible cells only command,copy visible cells and paste to visible cells,advanced excel,excel,excel basics,excel in 2 minutes,excel in two minutes,excel tips,excel tutorials,learn excel,sumit bansal,trump excel,