Upgrade Now

How to Add a Button in Excel

Jan 11, 2023

When using Excel, you have the power to include a macro-enabled button in your worksheet. This button allows you to run a macro with a simple click of the button.

You can use your macro buttons to execute various tasks, such as selecting data, running formulas, filtering data, and calculating.

Rather than spending hours clicking the Excel insert button trying to find these things, you can use a button to access them quickly and easily.

It might sound complicated to assign a macro button to a task in Microsoft Excel, but it is pretty easy.

This article will offer you a step-by-step guide on how to add a button in excel, so you can access aspects of Excel you frequently use with ease and create a customized ribbon to suit your needs.

Add a Macro Button Using Shapes

The first option to look at is creating a button in Excel utilizing shapes. Creating a button using shapes offers more formatting options compared to the other two options highlighted in this article, as you have the power to amend color, design, font, and other aspects of the button.

  1. Start by heading to the Insert tab and selecting Illustrations. From there, select the Shapes option and choose a rectangle button.

  1. From there, draw your rectangle on the spreadsheet.

  1. Next, enter your text into the button, double-click on it, and insert your text.

  2. Now click on the Shape Format tab, and you will get presented with several options to format your button. Here you can change the font color, style, button color, effects, and much more.

  3. Once you are happy with your button, choose the Assign Macro option.

  1. The Assign Macro dialogue box will appear, and you can choose the macro and select OK.

Add a Macro Button Using Form Controls Group

  1. Select the Developer tab, and select the insert button from the Control group located on the ribbon.

  2. From there, choose the first button option from the form control button group, and draw a button within your worksheet.

  3. Next, choose your macro name from the Assign Macro dialog box and select OK. Don't worry if you haven't created a macro yet. You can add this after if needed.

  4. Now right-click on your button, then select Assign Macro to include a macro within your button if not done already.

  5. Once complete, you can format your button's color, font size, and other features, just select Format Control.

Add a Macro Button Using ActiveX Controls

  1. Begin by heading back to the Developer tab, and selecting the Insert button from the Control group within the ribbon.

  2. However, rather than selecting the form control button, click on ActiveX Controls. You will then have the option a draw your button on the spreadsheet.

  3. To add your macros to the ActiveX button, select the View Code icon, and the VBA editor will appear.

  4. Choose CommandButton1, and select the Click option via the drop-down list.

Final Thoughts on Adding a Button to an Excel Workbook

There you have it, three easy ways to add a button in excel. You don't need to know VBA code or macro code to implement a button, just follow this simple step-by-step guide.

If you liked this tutorial, check out the other step-by-step guides on the Simple Sheets blog!

Frequently Asked Questions About Adding a Button in Excel

How do I create macro buttons in Google Sheets?

The steps outlined above will work in both Microsoft Excel and Google Sheets.

Are the ActiveX control buttons the same in Excel and Google Sheets

Yes! The steps highlighted above will work in Google Sheets as effectively as in Google Sheets.

Can I change the shape outline of my button?

You have the power to implement a shape outline or shape fill change to your excel button.

Related Articles

A Reference Isn't Valid Excel Error | How to Fix this Excel Error?

How to Add Leading Zeros in Microsoft Excel

How to Change Currency in Google Sheets

Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons

We hate SPAM. We will never sell your information, for any reason.