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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel’s Fill Handle Tips This post was inspired by Mr.Excel's new book MrExcel XL: 40 Greatest Excel Tips of All Time and in particular the 3rd tip that I read called The Fill Handle Does Know 1,2,3...Excel knows to fill down/right when you are working with dates, days, months, years and even quarter...
Convert Values to Dates Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is convert your values into Excel dates a...
Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like:John (john@email.com) ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...
Excel Table Headers Show in Columns Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality.For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you ...