Adding the Subtotals Icon to the Menu Bar in Microsoft Excel 2010

In this article, we will learn how to add the subtotal icon to the menu bar in Microsoft Excel 2010.

Subtotal: - This option is used to quickly calculate rows of related data by inserting subtotals and totals.
To add the Subtotal Icon to the menu bar, follow the below given steps:-

  • Place the mouse over one of the toolbars then, right click and select More commands from the Customize Quick Access Toolbar’s drop down menu.


  • Excel Options dialog box will appear.
  • Select All Commands from the Choose commands drop down menu.


  • All Commands will appear, find the Subtotal function, click on add button, and then click on OK.


  • Subtotal icon will appear on the top of the Excel Sheet.

After adding the Subtotal icon to menu bar, press the short cut key Alt+9 on your keyboard.

This is the how we can add the subtotal icon to the Menu in Microsoft Excel 2010.

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=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube