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…
- Select the range you want to copy (ctrl + A)
- Call up Go To (Ctrl + G)
- Click on the Special… button bottom left
- Select the Visible Cells only option and click on OK
- Copy (ctrl + C) and Paste (ctrl + V)
To learn more of these simple tips, and increase your overall proficiency, check out our basic Excel training course, ideal for beginners or those wanting to upskill their Excel knowledge.