PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO CUSTOMIZE QUICK ACCESS TOOLBAR

INTRODUCTION

QUICK ACCESS TOOLBAR is a small toolbar situated at the top in the left upper corner of the EXCEL.

The Quick Access Toolbar contains few of the selective options, out of which we can select which ones to be displayed, which are always visible at all the times.

We can make use of these options at any time of the working except the FULL SCREEN MODE.

The options available are like save, new, undo , redo  and many more which we will be discussing in the article.

WHAT IS QUICK ACCESS TOOLBAR IN EXCEL

QUICK ACCESS TOOLBAR is a small toolbar present on the upper left corner of the MICROSOFT EXCEL.
The toolbar consists of many useful tools such as SAVE, NEW WORKSHEET, REDO, UNDO etc. and is customizable.
The toolbar is always visible and have the direct access which can be used in a single click, hence the name QUICK ACCESS TOOLBAR.

WHERE IS QUICK ACCESS TOOLBAR LOCATED

The Quick Access Toolbar is located on the UPPER RIGHT CORNER of the EXCEL. It is located on the LEFT PORTION of the TITLE BAR of EXCEL.

WHERE TO FIND QUICK ACCESS TOOLBAR
LOCATION OF QUICK ACCESS TOOLBAR

HOW TO PLACE THE QUICK ACCESS TOOLBAR BELOW THE RIBBON

The Quick Access Toolbar is normally located at the top in the TITLE BAR.

If we want to move it under the ribbon [ If you like] we can do so using the following steps.

  • RIGHT CLICK the QUICK ACCESS TOOLBAR.
  • Choose SHOW QUICK ACCESS TOOLBAR BELOW THE RIBBON.
  • The toolbar will shift under the ribbon as shown in the picture.
MOVE QUICK ACCESS TOOLBAR UNDER THE RIBBON
MOVE QUICK ACCESS TOOLBAR UNDER THE RIBBON

HOW TO ADD COMMANDS TO QUICK ACCESS TOOLBAR

We can easily add the commands to the QUICK ACCESS TOOLBAR.

If we want to add the commands, follow the steps.

  • CLICK the DROPDOWN ARROW at the RIGHT END of the QUICK ACCESS TOOLBAR. [ You can also RIGHT CLICK and choose CUSTOMIZE QUICK ACCESS TOOLBAR ].
  • Choose MORE COMMANDS.
  • The Customize Dialog box will open.
  • Choose the commands from the left listbox and click ADD as shown in the picture below.
  • Click OK.
  • The command selected will be added.
  • If you want to select many commands, choose one by one and click ADD.
  • Finally Click OK.
  • The picture below depicts the process.
ADD COMMANDS TO QUICK ACCESS TOOLBAR

HOW TO REMOVE COMMANDS TO QUICK ACCESS TOOLBAR

We can easily add the commands to the QUICK ACCESS TOOLBAR.

If we want to remove the commands, follow the steps.

  • CLICK the DROPDOWN ARROW at the RIGHT END of the QUICK ACCESS TOOLBAR. [ You can also RIGHT CLICK and choose REMOVE FROM QUICK ACCESS TOOLBAR ].
  • Choose MORE COMMANDS.
  • The Customize Dialog box will open.
  • Choose the commands from the RIGHT LISTBOX and click REMOVE as shown in the picture below.
  • Click OK.
  • The command selected will be removed.
  • The picture below depicts the process.
STEPS TO REMOVE COMMANDS FROM QUICK ACCESS TOOLBAR

HOW TO CHANGE THE ORDER OF COMMANDS IN QUICK ACCESS TOOLBAR

We can easily change the order of the quick access toolbar commands but problem is that, the drag option is not present. We need to go inside the CUSTOMIZE QUICK ACCESS TOOLBAR DIALOG BOX.

If we want to change the order of the commands, follow the steps.

  • CLICK the DROPDOWN ARROW at the RIGHT END of the QUICK ACCESS TOOLBAR.
  • Choose MORE COMMANDS.
  • The Customize Dialog box will open.
  • Choose the commands from the RIGHT LISTBOX and click UP ARROW OR DOWN ARROW to set the order of the commands.
  • Click OK.
  • The requested order will appear.
  • The picture below depicts the process.
HOW TO CREATE CUSTOM ORDER OF QUICK ACCESS TOOLBAR
STEPS TO CREATE CUSTOM ORDER OF COMMANDS IN QUICK ACCESS TOOLBAR

HOW TO RESET QUICK ACCESS TOOLBAR

Suppose , we have created a lot of changes and we want to RESET all the customization of the QUICK ACCESS TOOLBAR. [ Resetting is the process of bringing the custom things back to the original state].

If we want to reset , follow the steps.

  • CLICK the DROPDOWN ARROW at the RIGHT END of the QUICK ACCESS TOOLBAR.
  • Choose MORE COMMANDS.
  • The Customize Dialog box will open.
  • At the RIGHT BOTTOM, we can see the option of RESETTING.
  • Choose the OPTION RESET QUICK ACCESS TOOLBAR from the RESET DROP DOWN and click OK.
  • The toolbar will be reset.
  • The picture below depicts the process.
HOW TO RESET THE CUSTOM SETTING OF QUICK ACCESS TOOLBAR
RESETTING QUICK ACCESS TOOLBAR TO INITIAL STATE

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected].com

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: