Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.
In this tutorial I show you how to copy and paste only the visible data – hidden cells are excluded.
To copy and paste only the visible data:
- First select the data range, including the hidden rows or columns.
- Press F5.
- Click Special and then select Visible Cells Only.
- Click OK.
- Now Copy the selected cells and then Paste them where required. Only the visible cells will be pasted.
We cover this and many more copying and pasting tips in our Excel Stage 1 courses.