What is the Quick Access Toolbar (QAT)?

This is a recommends products dialog
Top Suggestions
Starting at
View All >
Sign In / Create Account
language Selector,${0} is Selected
Register & Shop at Lenovo Pro
Register at Education Store
Pro Tier Benefits
• Save up to an extra 20% on Think everyday pricing.
• Spend $15K, advance for FREE to Plus Tier with increased benefits.
Plus Tier Benefits
• Save up to an extra 25% on Think everyday pricing.
• Spend $50K, advance for FREE to Elite Tier with increased benefits.
Elite Tier Benefits
• Save up to an extra 30% on Think everyday pricing.
Reseller Benefits
• Access to Lenovo's full product portfolio
• Configure and Purchase at prices better than Lenovo.com
View All Details >
more to reach
PRO Plus
PRO Elite
Congratulations, you have reached Elite Status!
Pro for Business
Delete icon Remove icon Add icon Reload icon
Temporary Unavailable
Cooming Soon!
. Additional units will be charged at the non-eCoupon price. Purchase additional now
We're sorry, the maximum quantity you are able to buy at this amazing eCoupon price is
Sign in or Create an Account to Save Your Cart!
Sign in or Create an Account to Join Rewards
View Cart
Your cart is empty! Don’t miss out on the latest products and savings — find your next favorite laptop, PC, or accessory today.
item(s) in cart
Some items in your cart are no longer available. Please visit cart for more details.
has been deleted
Please review your cart as items have changed.
Contains Add-ons
Proceed to Checkout
Popular Searches
What are you looking for today ?
Quick Links
Recent Searches
Hamburger Menu
skip to main content
Learn More      

What is the Quick Access Toolbar (QAT)?

The QAT is a handy feature in Microsoft Excel and Word that allows you to customize a toolbar with your most frequently used commands. It provides easy access to actions like saving, undoing, and redoing without navigating through menus. You can personalize it according to your workflow, enhancing efficiency in your daily tasks.

How can I customize the QAT in Excel and Word?

In both Excel and Word, customizing the QAT is a breeze. Click on the down arrow at the end of the toolbar and select "More Commands." From there, you can add or remove commands, rearrange their order, and even choose to display the toolbar below or above the ribbon. Tailor it to your needs for a more streamlined experience.

What commands are commonly added to the QAT?

Popular commands added to the QAT include Save, Undo, Redo, Copy, and Paste. These are actions frequently used in daily documents and spreadsheet creation. By having them readily available, you can save time and reduce the clicks needed for these essential functions, making your work more efficient.

Can I add custom commands to the QAT?

Absolutely, the Quick Access Toolbar (QAT) allows you to add custom commands that align with your specific needs. After selecting "More Commands," choose "Commands Not in the Ribbon," and you'll find a plethora of options. Whether it's a specific formatting command or a niche function, you can personalize your toolbar to enhance your workflow.

How does the QAT contribute to productivity?

The QAT is a productivity booster because it puts your most-used commands at your fingertips. Instead of navigating through various tabs and menus, you can perform essential actions with a single click. This streamlines your workflow, reduces the time spent on repetitive tasks, and ultimately enhances your overall efficiency in Excel and Word.

Can I reset the QAT to its default settings?

Yes, you can reset the QAT to its default settings if needed. Simply go to the customization menu, click "Reset," and choose either to reset only the toolbar or to reset all customizations. This is handy if you've made changes and want to start fresh or if you simply want to revert to the default configuration.

How does the QAT improve accessibility in Excel and Word?

The QAT improves accessibility by providing a shortcut for essential commands. For users with disabilities or those who prefer keyboard shortcuts, this feature allows for quicker navigation and execution of tasks. It reduces the reliance on mouse clicks, catering to a diverse range of users and ensuring a more inclusive experience in Excel and Word.

Could I have different QAT setups for Excel and Word?

Yes, you can have distinct QAT setups for Excel and Word. Customizations made in one application won't affect the other. This flexibility allows you to optimize the toolbar based on the specific commands and functions you frequently use in each program, tailoring the experience to your preferences and work requirements.

How can I add ribbon commands to the QAT?

To add ribbon commands to the QAT, right-click on the desired command in the ribbon and select "Add to Quick Access Toolbar." Alternatively, you can use the customization menu and choose commands from the ribbon. This feature ensures that your most-used commands, whether from the ribbon or elsewhere, are easily accessible.

What role does the QAT play in minimizing workflow interruptions?

The QAT minimizes workflow interruptions by offering a quick and direct path to essential commands. Instead of interrupting your flow to search through menus, you can swiftly execute actions like saving or undoing with a glance at the toolbar. This seamless integration enhances your concentration and keeps your workflow smooth in Excel and Word.

How does the QAT contribute to a personalized user experience?

The QAT contributes to a personalized user experience by allowing each individual to tailor it to their unique preferences. Whether you prioritize specific commands or need quick access to custom functions, this feature ensures that your most-used actions are within reach, creating a workspace that aligns with your workflow and enhances overall satisfaction.

Can I add macros to the QAT?

Certainly, adding macros to the QAT is a powerful way to streamline your workflow. In the customization menu, select "Macros" from the "Choose commands from" dropdown. You can then add your favorite macros to the toolbar, providing quick access to automated processes and further boosting your efficiency in Excel and Word.

How does the QAT adapt to changes in software updates?

The QAT adapts seamlessly to changes in software updates. Microsoft regularly enhances its applications, and while the overall layout may evolve, the toolbar remains a key feature. Your customizations persist across updates, ensuring that you can take advantage of new features without losing your personalized setup in both Excel and Word.

Can I resize or reposition the QAT for better visibility?

While you can't resize the QAT itself, you can opt for a more prominent display. In the customization menu, choose to show the toolbar below the ribbon, providing better visibility. Additionally, you can customize the ribbon's appearance to suit your preferences, ensuring that the toolbar remains easily accessible and visible in your Excel and Word workspace.

How does the QAT complement keyboard shortcuts in Excel and Word?

The QAT complements keyboard shortcuts by offering an alternative, mouse-centric way to access commands. This flexibility caters to users with different preferences. Whether you're a fan of keyboard shortcuts or prefer a visual toolbar, the QAT ensures that you can navigate and execute commands in Excel and Word according to your preferred interaction style.

How does the QAT contribute to a more efficient learning curve?

The QAT contributes to a more efficient learning curve by simplifying the access to essential commands. As you familiarize yourself with Excel and Word, having quick access to frequently used actions accelerates the learning process. The toolbar becomes an intuitive aid, reducing the time it takes to become proficient in these applications and enhancing overall user confidence.

coming coming
Starting at
List Price
Web Price
Web Price:
List Price
Web Price
List Price is Lenovo’s estimate of product value based on the industry data, including the prices at which first and third-party retailers and etailers have offered or valued the same or comparable products. Third-party reseller data may not be based on actual sales.
Web Price is Lenovo’s estimate of product value based on industry data, including the prices at which Lenovo and/or third-party retailers and e-tailers have offered or valued the same or comparable products. Third-party data may not be based on actual sales.
Learn More
See More
See Less
View {0} Model
View {0} Models
Part Number:
See More
See Less
Great choice!
You may compare up to 4 products per product category (laptops, desktops, etc). Please de-select one to add another.
View Your Comparisons
Add To Cart
Add To Cart
We're sorry,
Products are temporarily unavailable.
Continue shopping
Learn More
Coming Soon
Featured Product
Top Deals of the Day
Oops! No results found. Visit the categories above to find your product.
open in new tab
© 2024 Lenovo. All rights reserved.
© {year} Lenovo. All rights reserved.
Compare  ()