View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mongoose Mongoose is offline
external usenet poster
 
Posts: 2
Default How do I copy subtotals from excel without it also copying the



"Andy B" wrote:

Hi
Reduce the amount of subtotal detail to what you require. Hit F5 and click
on Special and then Visible Cells Only. You can now use Ctrl+C to copy this.
Go to where you want to paste these totals, and use Edit|Paste
Special|Values to paste.

--
Andy.


"slh" wrote in message
...