Here's our Microsoft Office Tip for.. December 21, 2004
Click Here to see a complete list of all of our previously released Tips!
Exclude Hidden Cells
It's easy to summarize data, but not so easy to copy just the summarized data. For instance, you can hide detail data while displaying only subtotals and grand totals. However, when you copy those totals, you'll also copy all the hidden detail data.
There is a way to copy just the visible data. Before you copy the summary totals (or data), choose Edit, Go To; click the Special button; and select the Visible Cells Only option. Next, select the cells that contain your summary and continue with your copy routine. Excel will paste only the visible cells to the target range.