tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Creating a button in Excel 2007

Question: I knew how to create a button in Microsoft Excel 2003, but how do I create a button in Excel 2007?

Answer: To create a button in Excel 2007, click on the Microsoft Office button Microsoft Excel in the top left of the Excel window and then click on the Excel Options button.

Microsoft Excel

When the Excel Options window appears, click on the Popular option on the left. Select the option called "Show Developer tab in the Ribbon". Then click on the OK button.

Microsoft Excel

Select the Developer tab from the toolbar at the top of the screen. In the Controls group, click on the Insert button and a menu will popup. Click on the button icon under the Form Controls section (see picture below) in the popup menu.

Microsoft Excel

Position your cursor in the spreadsheet and hold down the left mouse button and drag until your button is the correct size. Then let go of the left mouse button. A button will appear on your spreadsheet as follows:

Microsoft Excel

Immediately, an Assign Macro window will appear. Select the macro that you wish to assign to this button and click on the OK button.

Microsoft Excel

If you wish to change the text that appears on the button, highlight the button text and type the text that you wish to appear in the button object.

Microsoft Excel