Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Creating Shortcut Buttons In MS Excel 2007

Its a task going through the entire menu to select a command that you wish to use. So to make things easy, let us see how we can create shortcut buttons here in MS Excel 2007, for the commands that are used frequently by you and can be accessed with a click of the mouse like Email, Open, Print, Print Preview etc. As shown above, we have created a shortcut button apart from the default ones. Generally Excel 2007 comes with 3 default shortcut buttons. On the top left of your excel screen just next to the file button you will see a drop down arrow. Once you click on it you will have a list of commands that you can select to have as a shortcut for yourself. Let us illustrate, how. As an example, we select Open & Print command to have as a shortcut there. As soon as you select the command it will be shown as a shortcut button for your quick and easy access. Now, you can go beyond select more commands which are not in the drop down list too. For that, click on “More Commands” from the drop down list. As soon as you click on “More Commands” a box will pop up with a list of commands as shown below. In order to form a shortcut from the list in the above box just click on the command and press add. You can select as many commands you want to add and once done just click on “OK”. Here we have selected three commands: Calculate now, Create chart and Insert cells. As soon as you press "OK", the shortcuts will be created. In order to remove the shortcut button, all you have to do is right click on the command and click on “Remove from Quick Access toolbar” option. Similarly you can do it for all the buttons you wish to remove.
0 comments:

Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits