In general, when you hide rows or columns or rows and columns, and you are trying to copy just the visible cells in your table to somewhere else, instead of copy just the visible cells on your table, Excel is going to copy everything.
In this tutorial I will be showing you how to use the Go To Special feature to copy and paste just the visible cells in Excel.