How to paste grouped rows without copying over the detailed items?

B

Brad

I would like to copy & paste only the summary grouped line but not the
detailed information. If you select "Paste Special, Values" the grouped
items expand but I only want the summary line and not the detailed lines
below.

Is there a way to copy and paste only the grouped information and exclude
the details below?
 
J

James

Yes, this can be done very simply.
Highlight the cells you want to copy.

Edit/Go to or Ctrl + g
Special / check Visible cells only
Then copy
Paste special/values

hope this helps and that I understood you correctly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy rows and paste onto visible only 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
How to sort by grouped rows 2
How to search for grouped rows? 1
Cut and Paste Macro to new file 1
Filter, Copy and Paste 2
Presenting Subtotals only 2
Apply "Description/City" to the Grouped Items 1

Top