Copy Visible Cells Only

Please purchase the course before starting the lesson.

Whether you hide or group rows and columns, when you copy over them you normally DON’T want them to come with. But by default Excel will copy the visible and hidden cells.

You can use the GOTO Special tool to only copy the visible cells. Excel highlights only the visible cells (note the thin white line at the bottom of row 6).

GoTo Special

If you copied and pasted this now, only the visible cells would be copied.

To see the full course contents click here.

Back to: Intermediate Excel Course > The Specials- GOTO and Paste