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. Once ...

But cell ranges also might have more complicated borders, mixing solid and broken lines or incorporating several colors. Copy and paste these styles with Excel's Format Painter tool. How to ...