How to Create a Command Button in Microsoft Excel

1. Open the Excel worksheet in which you will be installing the command button.
2. Click the Microsoft Office logo located in the top left-hand corner of the screen and choose 'Excel Options.' Check 'Show Developer Tab' under the Top Options tab, and click 'OK.'
3. Click the 'Developer' tab on the main menu ribbon. Open the 'Insert' drop-down menu, and click 'Command Button.' Select the area of the worksheet where you want to insert the command button, and click on it. The command button will appear.
4. Click the 'Developer' tab on the main menu ribbon and select 'Design Mode.'
5. Right-click on the command button that you just created and select 'Properties.' Select 'Text' to add a caption to the button. Select 'Size' to edit the size and position of the command button. Select 'General' to edit the function of the button. Choose 'AutoLoad' if you want the button activated every time the workbook is opened. Choose 'Placement' to edit the movement of the button on the workbook page. Click 'OK' to save the the command button properties.
6. Right-click on the command button and choose 'Assign Macro.' Select the action that you want the button to perform from the macro list. Click 'OK' to save the command button.