Excel Tips | Adding Macros to your toolbar

So lets see some tips about excel .we know what is macros and its importance so how can
we add macros on our toolbar here is the tip

a.Choose Customize from the Tools menu. Excel displays the Customize dialog box.
Make sure the Toolbars tab is selected.

b.In the list of toolbars, make sure there is a check mark beside the toolbar to which you want your macro added. The check mark ensures that the toolbar is displayed on the screen.

c.Click on the Commands tab.

d.In the list of Categories, choose the Macros entry. Your macros should then appear in the Commands list.

e.In the Commands list, select the macro you want assigned to a toolbar.

f.Using the mouse, drag the macro from the Commands list to the location on the toolbar where you want it to appear.

g.When you drop the macro, it appears on the toolbar.

h.To add more macros, repeat steps 6 through 8.

i.Click on Close and then you can see your result at you toolbar


Hope you liked it..