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.
Select Visible Cells Only, then click OK. (The shortcut to select visible cells is ALT semi-colon.)
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.
Click to Grab Your Excel Ebook – Free!
