Copying subtotals

Resolved · Low Priority · Version 2007

Thu 19 Jun 2014, 16:23 Delegate Fabio said...

Fabio has attended:
Excel Intermediate course
Excel Advanced course

Copying subtotals

after getting the subtotals from a worksheet, would like to copy just the subtotals without the hidden data into a new worksheet, how do I do that?

Mon 23 Jun 2014, 12:32 Trainer Marius said...

RE: copying subtotals

Hello Fabio,

Thank you for your post. To copy subtotals to a new worksheet without the background data, you select the subtotals (I assume you are collapsing the sheet so that only the subtotals are showing), then press F5 (Function 5 key). This opens the Go To box.

Click the Special button at the bottom of this box. In the Go To Special box, select "Visible cells only". After this, press Ctrl + C to copy your selected range. In the new worksheet, simply press Ctrl + V to paste the subtotals. The key here is that you've told Excel to copy only the visible cells, i.e. the subtotals.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer
Best STL

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips