How do I copy and paste only visible cells in Excel 2010?
How do I copy and paste only visible cells in Excel 2010? Follow these steps: 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 Read more…