Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Copying Subtotals.
Excel has a handy feature that allows you to automatically add subtotals to a data list. (How to create subtotals is covered in other issues of ExcelTips.) You may be wondering, once the subtotals are in place, how you can copy the subtotals to a different worksheet. This is actually rather easy to do, if you follow these steps:
Figure 1. The Go To Special dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10677) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Copying Subtotals.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
What do you do if a keypress you know worked correctly before all of a sudden stops working as you expect? This tip ...
Discover MoreAutoComplete can help you to more quickly enter information in a worksheet. How it works, behind the scenes, can affect ...
Discover MoreExcel provides keyboard shortcuts for a variety of purposes. This tip examines two such shortcuts, designed to allow ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-01-30 14:31:58
Mary
Thank you! This is sooooo helpful! Really appreciate you posting this tip.
2014-12-27 00:14:26
Arun S Nanda
copying the sub total column was really a botheration to me. I used to copy each cell separately. now this will be a easy thing to me. thank you very much.
2014-12-22 10:23:18
Jennifer Thomas
Thanks, Jerry - that's a good shortcut!
2014-12-22 10:11:11
Charles Ellis
If a range of cells has been formatted as a "table", the sub-total function does not appear to be available.
2014-12-20 11:00:13
Jerry
A handy shortcut to replace steps 4-6: after selecting the range of subtotals, press Alt+; (semicolon). This shortcut selects all visible cells in the selected range.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments