Add frequently used Commands to Quick Access Toolbar for Easy Access

image_pdf


We use some commands of Excel more often then other. Quick Access Toolbar provides us easy access of most frequently used commands. Excel also provide feature of customization of Quick Access Toolbar. Here is the way to customize and create your own customized toolbar.

Follow this steps to Customize Quick Access Toolbar in the ribbon.

1. Quick Access Toolbar is the bar at the Top of Excel above Ribbon.

Quick Access 1

2. Click on the Down Arrow and Select More Commands.

Quick Access 2

3. In Excel Options dialog box, select Quick Access Toolbar. Then select commands from Left side and Add it to the Right side box. Click OK.

Quick Access 3

4. You can see that Quick Access Toolbar is now customized with you added command.

Quick Access 4

5. If you want to display Quick Access Toolbar below the Ribbon, click on the checkbox as shown in

Quick Access 5

6. Quick Access Toolbar is shown below the Ribbon.

Quick Access 6

Explore more, It's Amazing…

How to Customize Ribbon in excel 2010?

10 Best Tips to Format your data quickly

Impress your boss using Pivot Chart

1,488 total views, 2 views today

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>