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.

Adding "Save" Button in Excel If you want to add a VBA save as button in Excel, you can do so using the "Developer" tab in the ribbon menu.

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.