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

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-subtotals/adding-the-subtotals-icon-to-the-menu-bar.html
SHARE




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.
 
img1
 
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.

 
img2
 

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

 
img3
 

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

 
img4
 

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

 
img5
 
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.
 
 

Please follow and like us:
0


Leave a Reply

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

To avoid automated spam,Please enter the value *

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>