Copy Only Visible Cells
If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. For example, you can choose to copy only the displayed summary data on an outlined worksheet.
1. Select the cells you want to copy.
2. On the Edit menu, click Go To.
3. Click Special.
4. Click Visible cells only, and thenclick OK.
5. Click Copy on the Standard toolbar.
6. Select the upper-left cell of the pastearea.
7. Click Paste.
Notes: Microsoft Excel pastes the copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells. If you click the arrow next to Paste, you can choose from several paste options to apply to your selection.
When you copy or paste hidden or filtereddata to another application or another instance of Excel, only the visible cells are copied. (The AutoFilter command is used to display rows that match one or more specific values, calculated values, or conditions.)
