====== Microsoft Excel - Copy - Copy visible cells only ======

If some cells, rows, or columns on a worksheet do not appear, there is the option of copying all cells—or only the visible cells.

  * By default, Excel copies hidden or filtered cells in addition to visible cells.

To copy only the summary data from an outlined worksheet.

  * Select the cells that to copy.
    * Click **Home -> Find & Select -> Go To Special -> Visible Cells only**.
    * Click **Home -> Copy** (or press CTRL-C).
    * Paste (or press CTRL-V).