Copying Subtotals

  • Thread starter Thread starter Gale
  • Start date Start date
G

Gale

After a spreadsheet has been subtotaled, is there a way to
copy the subtotals only and paste to another document?

Thanks.
 
Hi
try the following after creating the subtotals
- group the range so that only the subtotals are visible
- select the range
- hit F5, click 'Special' and choose 'only visible cells'
- after this copy the range and paste it to a different location
 
You must log in or register to reply here.

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

Average of Subtotals in Pivot Table 0
Using the Subtotal function 2
Additonal info into newly created Subtotal row 1
Subtotal of adjacent coloumn 4
Subtotaling 3
Subtotaling 1
SubTotal 1
Subtotals 1

Back
Top