How to copy only visible cells in Excel Excel provides a built-in ‘ Go To Special – Visible Cells Only ‘ feature that selects only the visible cells within a selected data range.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.