How to Copy only Subtotal Rows : Excel

How to Copy only Subtotal Rows : Excel

Many times while working in Excel, we need to copy only subtotal rows. Following are the way to copy only subtotal rows in Excel.

Solution:

Hide the Detail Rows i.e. Show only Sub-total Rows.

Select “Go-To” or <Ctrl> + <G>. Select “Special”.

Select visible fields only.

yes, you have done. Now copy and paste the data.

Please share the post and subscribe our website. Please use comment section below for your suggestions, comments or questions.