View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ScottFisher2004 ScottFisher2004 is offline
external usenet poster
 
Posts: 6
Default Copying Cells in List

Copy the subtoal cells. Go to where you want the values pasted. Then select
Edit from the menu bar, Paste Special from the drop-down, click 'values', and
select okay.

"infinite1013" wrote:

If i have my cells sorted and subtotaled and close the brackets to show only
the subtotals, is there a way that I can copy only those subtotals without
copying all of the figures that make them up?