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

Turn Text To Values With Paste Special Values Many times you would have received data from your IT system which is formatted wrong!  Well a gazillion times if you work in a mid sized firm 🙂 When you try and sum the values you get a count rather than a sum, that is because Excel reads the data as text rather than a value....
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list. A dynamic drop down list expands as the Excel Table expands when new data gets added to it. This is great when you want to have users select from a predefined ...
How To Create A Custom List In Excel   A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers. The main goal of a custom list is to remove repetitive work and manual errors i...
Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format. I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with. DOWNLOAD EXCEL WOR...