Select Visible Cells Only in Microsoft Excel / Excel Tutorial

When you want to copy data without including the hidden rows, you'll need to use the "Select Visible Cells" option in excel. This can be done by adding a special icon/button to the quick access tool bar, or using a keyboard shortcut. We will also show you how to cancel a copy action, and remove that copy data from the clipboard.