Thursday, July 11, 2013

How to Put a Command Button on a Spreadsheet in Excel


1. Open the spreadsheet in Excel that you want to add a command button to. Click the 'Office File' button on the main ribbon and click 'Excel Options.' Enable 'Show Developer tab in the ribbon' if it isn't already checked and click 'OK.'
2. Click the 'Developer' tab, then click 'Insert.' This brings up the list of controls that you can insert. Click the 'Button' link from the list of options.
3. Click in the spreadsheet where you want the command button to be placed.
4. Choose a macro from the list to assign to your command button, then click 'OK.'
5. Right-click the button and click 'Format Control' to format how the button looks.

Blogger news