How to Add Buttons to an Excel Spreadsheet

1. Access the Button tool. In Excel 2003 and earlier versions, do this by clicking 'View,' 'Toolbars,' 'Forms' and then clicking the Button tool on the Forms toolbar. In Excel 2007 and later, select the 'Developer' tab, then click 'Insert' and select the Button tool.
2. Click where you want the top-left corner of your button to be, and drag to create a rectangular outline. Let go and your button will appear.
3. Right-click the button and click 'Assign Macro.' This will bring up a dialog box listing all of Excel's saved macros. (The box may appear as soon as you've created the button, without the need for the 'Assign Macro' menu selection.) Click on the macro you want and click 'OK.'
4. Right-click the button again. You can now click within the text on the button to change it as you would with any MS Office text. Give the button whatever name you want. You can also right-click on the button's outline and click 'Format Control' to change the font of the button's name.
5. Click the button to run the assigned macro.