The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.  The QAT is unique to each user´s workbook settings.

You can move the QAT below or above the ribbon by right clicking on the QAT and making the selection.

You can also add your favourite commands to the QAT by right clicking on your favorite command in the ribbon and selecting Add to Quick Access Toolbar.

Finally, you can call your QAT commands by pressing the ALT key on your keyboard and then pressing the number (e.g. 1,2,3 etc) that appears at the bottom of that command.

 DOWNLOAD WORKBOOK

QAT

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Text To Columns: Dates Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes. Sometimes "Date" values are downloaded as "Text", so you cannot sort in the periodic date format. No worries!  Text to Columns ...
Top Excel Data Cleansing Techniques Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it. So what is data cleansing? In the words of Oz du Soleil, Excel MVP, it is like "Hercules being sent out to capture the three-he...
Excel’s Subtotal Feature Excel´s Subtotal feature is a great way to automatically insert a Sum/Count/Average/Max/Min subtotal to your data set with a press of a button. This feature is located under the Excel Data tools menu: Data > Subtotal.  To insert this feature you need to follow these quick s...
Excel Table Slicers Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons. You can see the power of Slicers and the different ways you can format them in these posts: https://www.myexcelonline.com/category/pivot-ta...