excel 2016 quick access toolbar close command

When you get the time, you might want to examine that list for the fun of it. The second choice for the list of filters is intriguing: Commands Not in the Ribbon.

Choose File, Options and then click the Quick Access Toolbar tab.Īny of these actions will display a large dialog that includes this area:Īrea 1 is a dropdown list box that allows you to filter the commands you see in area 2.

Left-click the right-most icon in your QAT-the one with the tiny down-pointing arrow.

Right-click any tool in your QAT and choose Customize Quick Access Toolbar….

I can think of at least three ways to do that: To modify the QAT, you first need to click the Quick Access Toolbar tab of your Excel Options dialog. Your QAT is the toolbar that’s at the very top of your screen by default. For two, I just use Ctrl+1 to access the Cell Properties, and Number Format usually comes up by default.I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself.īefore I get into the tools, let’s start with a quick look at how to add tools to your QAT, and how to remove them. For one, I've got a button that fires a macro to cycle through my most common number formats (comma, no decimal -> Accounting -> percent, 1 decimal, and red parenthesis negatives -> General).

csv in specific folder close fileĪs for adding Number Format, I've never needed to add it to the tool bar. csv for upload into another system)ĭown Arrow - Save file as. Hierarchy Thingy - Removes all line breaks/carriage returns (needed for saving as. Single Grid - Formats and pivots one of the files I use daily to extract the numbers I needĭown Arrow - changes selected pivot table to sort fields in alphabetical order in field list (selecting again changes fields back)ĭefault Macro Image - removes any non-default Styles Push Pin - Adds filters, freezes top row (cycles through several modes on multiple pushes)

Here's mine from my battle station at work (my home toolbar is less intense).

Excel 2016 quick access toolbar close command