Copy and Paste excluding hidden Rows and Columns

Normal copy and paste includes hidden rows and columns, so how do you Copy and Paste just the cells that are visible? Select Visible Cells only before copying. The quick guide…

1. Select the range you want to copy (ctrl + A)
2. Call up Go To (Ctrl + G)
3. Click on the Special… button bottom left
4. Select the Visible Cells only option and click on OK
5. Copy (ctrl + C) and Paste (ctrl + V)