MrExcel.com - Your One Stop for Excel Tips & Solutions

Copy Subtotals

August 04, 2017 - by

Copy Subtotals

Copy to add subtotals.

Once you’ve collapsed the data down to the #2 view, you might want to copy the subtotals to a new worksheet. If so, select all the data. Press Alt + ; to select only the visible cells. Press Ctrl + C to copy. Switch to a new workbook. Press Ctrl + V to paste. All the subtotal formulas are converted to values.

Thanks to Patricia McCarthy for suggesting to select visible cells. Thanks to Derek Fraley for his "row 6" suggestion.

Watch Video

  • Copy Subtotals
  • Collapse to #2 View
  • Copy the subtotals
  • New workbook & paste. All the detail rows appear
  • Finding Go To Special via the Go To Dialog
  • Visible Cells Only
  • Copy - you can see the difference with the marching ants
  • New workbook & paste. Only the subtotals, pasted as values
  • Thanks to Patricia McCarthy for suggesting this tip

Download File

Download the sample file here: Podcast1997.xlsx

Title Photo: PublicDomainPictures / pixabay