excel 2016 quick access toolbar icons very big

This file has all the QAT buttons you created earlier

Go inside the userCustomization folder and open the only file inside - customUI.xml.

Change extension of OneWorkbookQAT.xlsm to.Edit the (currently empty) QAT as usual, add whatever buttons/macros you want.Go to File -> Options -> Quick Access Toolbar and on the right hand side under the option Customize Quick Access Toolbar select For OneWorkbookQAT.xlsm.For simplicity I just removed the default QAT for all documents and have all my settings stored in this addin. You'll need to create a workbook-specific QAT, add your custom macros there, manually edit the image names and then save this file as an auto-loading addin, so that your custom QAT is always loaded and your custom icons are not overwritten during edits of the default QAT. the name of the icon with a zero on it is _0 there might be a more convenient alternative to find icon names, but this was sufficient for my needs of a few icons)Įditing QAT: Below you'll basically find an edited version of instructions from this awesome site Customize QAT Icons, where I originally found the solution. Choose the ones you need and write down their names from this Icons Gallery (e.g.

Icons: as far as I understand, you can only get the stock MS Office icons (which is still a lot more than that measly default selection you're allowed to pick from).

Excel 2016 quick access toolbar icons very big