Ask Jackie: How to Copy Excel Subtotals to A New Workbook

Untitled Document

This question came in via email recently:

Jackie, a quick question. When I do subtotals, how can I copy just the totals to a new Excel workbook?

Brief Answer:

I’m glad you asked! The key to making this work is selecting the visible cells only. While there is a shortcut (which I will mention), I prefer using the GoTo dialog box for its added functionality and flexibility.

Step-by-Step Tutorial:

Collapse the rows so that only your subtotals are showing.

Click CTRL G to open the GoTo dialog box.

Click the Special button.

Go To Dialog Box by ExcelTrainingAtlanta.com

Select Visible Cells Only, then click OK. (The shortcut to select visible cells is ALT semi-colon.)

Excel GoToSpecial dialog box by ExcelTrainingAtlanta.com

Copy the visible cells (CTRL C) and paste them in the new workbook (CTRL V).

Do you have an Excel question?

Comment below and it just might make it to a blog post!

About the Author

Jackie Kiadii and her team of subject matter expert (SME) trainers provide Microsoft software training that delivers measurable results – increasing productivity, reducing inefficiency, and improving the bottom line. Topics include: Project, Access, Excel, Excel VBA, PowerPoint, Word, Outlook and Publisher. Upcoming Excel courses are on our calendar, click here.

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>