Jump to content

Copy subtotals


Recommended Posts

Copy subtotals

When you apply Data Subtotals, Excel automatically displays outline symbols to the left of the spreadsheet. Using these symbols, you can collapse the data to show only the subtotals and the grand totals. For instance, you could show the total monthly payroll for each employee, without the weekly details. However, when you try to copy and paste the monthly subtotals, both the detail rows and subtotals are pasted to the new location.

To copy only the subtotals, use the Go To command with Copy. Follow these steps:

1. Collapse the subtotals to display only those you want to copy.

2. Select the subtotals to copy.

3. Go to Edit | Go To, and click Special.

4. Select the Visible Cells Only option, and click OK.

5. Click Copy.

6. Move to the cell where you want to copy the subtotals, and click Paste.

Combining Go To with Copy enables you to copy the subtotals without the details.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...