['Select the cells that you want to copy For more information, see Select cells, ranges, rows, or columns on a worksheet. ... ', 'Click Home > Find & Select, and pick Go To Special.', 'Click Visible cells only > OK.', 'Click Copy (or press Ctrl+C).', 'Select the upper-left cell of the paste area and click Paste (or press Ctrl+V).']