Thread: How do I copy and paste only the sub-total from a list
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrea Jones Andrea Jones is offline
external usenet poster
  
Posts: 63
Default How do I copy and paste only the sub-total from a list
Highlight your collapsed subtotals and press CTRL+G. Click the Special
button and click to place a bullet beside Visible Cells Only. Click OK and
press CTRL+C to copy, this will copy only the displayed cells and you can now
use CTRL+V to paste as normal.

Andrea Jones
www.allaboutclait.com

"Klutz" wrote:

I have an Excel spreadsheet which consists of data with sub-totals. How do I
copy and paste only the sub-total values to another spreadsheet?
Reply With QuoteReply With Quote