Make a Copy That Excludes Hidden Cells

Hits:19

When you use outlining or subtotals to create a small summary of a large set of data, you can make a copy of just the displayed cells in the summary, excluding the detail. First display only the summary rows or columns, and then select all of the summary data. On the Edit menu, click Go To, click Special, and then click Visible cells only. Now click the Copy button, click a cell on a blank worksheet, and click the Paste button. The copy includes only the summary data. For more information about subtotals and outlines, type inserting subtotals and creating outlines in the Office Assistant or on the Answer Wizard tab in the Excel Help window.