SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

If you want to select copy paste only the visible cells in Excel:

In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in
On the HOME tab, click SELECT GOTO
Click GOTO SPECIAL
Click VISIBLE CELLS ONLY
Right click on the cells you selected in step 1 and click COPY
Paste the cells wherever you want and you will see it took only the visible cells

Peace says:

April 10, 2020 at 11:19 am

Thank you for this video about how to paste visible cells only. It works only if you paste the cells on a different sheet where cells are not hidden. If I try to copy from Col. A and paste it on Col. B on that same sheet where some cells are invisible, it does not work.
Can you please advise? I am using office 365.
- Ian Matthews says:
  
  April 13, 2020 at 8:04 pm
  
  Hi Peace;
  
  That makes sens. If the rows are hidde, they will be hidden when you paste. You could paste into a different worksheet (as you suggest) or workbook.