Sub-Totals Question

S

SBoak

Hi Folks:

I have a small sheet of about 150 rows and 25 columns that represent sales
results.
I have a report set up in Sub-Totals, and I'd like to just copy the Total
data.
But when I copy and use Paste or Paste-Special, all the rows that are hidden
get un-hidden . . .
Is there a way to just get the sub-totals to paste ??

Thanks Much
Steve
 
P

Per Erik Midtrød

Yes and it is quite easy to do.
Make sure that only the subtotals are visible.
Then choose Go to - special and choose visible cells.


Per Erik
 

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

How do I copy and paste only the sub-total from a list 3
can i automatically copy subtotals in excel to another s/sheet? 1
summaries on alternative sheets 6
Working out VAT owed 1
Changing formula totals 2
Copy formula from one worksheet to another to get value in 2nd wks 1
Sorting Existing Totals Into A New & Separate Column 1
inserta row and affect same formula on same sheet 1

Top