Copy Visible Cells Only
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).
If you copied and pasted this now, only the visible cells would be copied.
To see the full course contents click here.