Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.