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.

Now that I have shown you how to create a button within an Excel spreadsheet, I want to move forward with using that button to launch a PowerShell script. I will show you how in Part 2.

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.