How to drag your quick access toolbar above the ribbon in Microsoft Excel

In this article I am going to explain, step by step, how to drag your quick access tollbar above the main menu, near the save button.

The Quick Access Toolbar is a convenient place to add your favorite commands. First, I’ll show you how to move your favorite commands to the Quick Access Toolbar

How to Add Your Favorite Command to the Quick Access Toolbar

Lett me first explain how to pin your favorite command to the Quick Access Toolbar and then I will show you how to place it both aboveand below the Ribbon.

To add a command to the Quick Access Toolbar — such as Conditional Formatting — right-click the command. You’ll see an option to ‘Add to Quick Access Toolbar’, select it, and the command will appear in your Quick Access Toolbar.

After clicking, you’ll see Conditional Formatting on the left side of your Quick Access Toolbar.

But how do you add it above the Ribbon (main menu)?



To move a command above the Ribbon, click on the button next to it in the Quick Access Toolbar.

 


By selecting ‘Show Above the Ribbon,’ you can place the command above the main menu.


Now, the Conditional Formatting command is above the Ribbon in the Quick Access Toolbar.


How to Remove a Command from the Quick Access Toolbar?

To remove your favorite command from Quick Access Toolbar you just need simply right-click on your favorite command in the Quick Access Toolbar and you will be able to put it in the original position.

Advertisement Placement

Advertisement Placement

Leave a Comment
Your Comment"

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

How to Use Excel’s AutoFill with Shadowed Suggestions
How to Use Excel’s AutoFill with Shadowed Suggestions

Excel Tips: Using AutoFill with Shadowed Suggestions for Quick Data Entry When you have...

Learn More
How to pull data from another sheet in Excel

In this article i will explain how to pull data from another spreadsheet in...

Learn More

Advertisement Placement

Menu

We use cookies to analyze activity on our site. By continuing to browse, you accept our terms of use.

What are we looking for? For example,Кредит