If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to Copy/Paste Only the Subtotal Rows in Excel?
I'm trying to copy and paste just the subtotals from an
Excel worksheet list into another list. How do I do this without also copying/pasting the underlying details (records)? Thanks. |
#2
|
|||
|
|||
How to Copy/Paste Only the Subtotal Rows in Excel?
"GBO" wrote in message
... I'm trying to copy and paste just the subtotals from an Excel worksheet list into another list. How do I do this without also copying/pasting the underlying details (records)? Thanks. Collapse so that only the subtotal rows are visible. Select the appropriate rows. Now the important step. Use Edit Go To Special Visible cells only. Then copy and paste as normal. |
Thread Tools | |
Display Modes | |
|
|