Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - copy subtotal rows only
I have data in multiple colums that has been subtotalled by the sum function.
I now wnt to copy and paste or export only the rows containing the subtotals to a new sheet. When I do this I get all the rows! It does work if I use the CNTRL key to mark all the individual cells and then paste values only but I find this a dreadful solution. Surely there is an easier way? |
#2
|
|||
|
|||
One way:
click the 2 in the outline box to hide the data rows Highlight the range of subtotals F5Specialclick on visible cells only CopyPaste SpecialValues HTH "Russ" wrote: I have data in multiple colums that has been subtotalled by the sum function. I now wnt to copy and paste or export only the rows containing the subtotals to a new sheet. When I do this I get all the rows! It does work if I use the CNTRL key to mark all the individual cells and then paste values only but I find this a dreadful solution. Surely there is an easier way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |