The Select Visible Cells Only function is so useful, I like to add it to the Quick Access Toolbar (QAT) in Excel. These instructions are based on Excel 2010, but will be similar in all current versions of Excel.
The Quick Access Toolbar starts in the top right corner of the Excel window. The customize button is circled in red. Clicking on that button displays the menu shown below.
The first change I like to make is to its’ position. I like to move it under the Ribbon, since there will be more room for buttons there. Over time I tend to fill the QAT up with frequently used tools.
After I move the QAT below the ribbon, I go hunting for useful commands to add. Click the More Commands… option and the Customize the Quick Access Toolbar dialog opens up.
The dialog box defaults to Popular Commands. Try scrolling through this list and find the Format Painter. Press the Add button, to add it to the Quick Access Toolbar. This is a useful tool to have at hand!
By clicking on the Choose commands from drop-down list, a selection will be displayed.
Select All Commands from this list. Hundreds of Excel commands will display, and this is where it is useful to know the name of the command you are looking for. Scroll until you find Select Visible Cells.
Select it, Click on the Add button, and click OK.
Simply select the cells you wish to copy and press the Select Visible Cells button. Paste your information and only what you see will be pasted.
This post is originally from 2016. If you want help with the newest and classic features in Excel drop me a line at firstname.lastname@example.org