Insert Button In Excel

Publication Date :

Blog Author :

Edited by :

Download FREE Insert Button Excel Template and Follow Along!
Insert Button Excel Template.xlsx

Table Of Contents

arrow

What Is Insert Button In Excel?

The Insert Button in Excel is a feature used in macros and VBA to insert asingle-click command button to perform a certain task for us. It helps us assign a Macro code to the Form Control button, so we can run the code with just a click on the button.

For example, we will create a Macro on Name and Date of Birth, and assign a button as “Name_Birth” to run the Macro Code, as shown below.

Insert Button in Excel - Example

It is an interactive button, as per the created Macro Code. Whenever we click the button, the Macro Code executes. Let us understand in detail in the article.

Key Takeaways

  • The Insert Button in Excel helps users add interactive buttons in the Excel sheets using the Developer tab.
  • While inserting a button in Excel, we must always remember to make the control option accessible so that everyone can understand the same and find the information.
  • We can only add one checkbox button at a time. Once we add the first control, “Copy” and “Paste” the control option to the rest of the cells and assign Macros to each of the controls.
  • While adding a button, always ensure that the text and the button’s size should be almost the same. Also, do not use the thick line for the box because we will not be able to see what is shown on the button.

How To Insert Button In Excel?

The Excel Insert Button is inserted as follows:

  1. We can insert it by enabling the “Developer” tab.
  2. In the “Insert” form controls in excel, we can find button options to insert.
  3. Then, we can draw the button on the worksheet.

Normally, the button is in the “Design Mode”, but we can remove it after coding and use it. While using the “Insert” option, first, we need to insert the “Developer” option in the Excel ribbon.

Steps To Insert Developer Option In Excel Ribbon

The steps to Insert Developer Option in Excel Ribbon are as follows:

  • Step #1 - We must first go to the “File” tab, and click on the “Options” at the bottom of the file option, as shown below.
Insert Button Step 1
  • Step #2 - When we click on “Options,” it enables one dialog box and goes to “Customize Ribbon in excel:
Insert Button Step 2
  • Step #3 - Now, we can see so many options under the “Customize Ribbon” tab. Click on the checkbox adjacent to the “Developer,” enabling the “Developer” option in the Excel ribbon:
Insert Button Step 3
  • Step #4 - Check/Tick the developer option, and click OK to confirm the same:
Insert Button Step 4
  • Step#5 - Now we will see the developer tab in you excel ribbon option as shown below:
Insert Button Step 5

How To Make Use Of Insert Button Option In Excel?

The Excel “Insert” button is used to add the control in the documents.

E.g., checkbox, scroll button, etc.

Below are the steps for using the Insert Button Option in Excel

  1. We must select the data first and organize the data as per the requirement.


    Insert Option Step 1

  2. Then, go to the “Developer” tab, and select the “Insert” option under the tab.


    Insert Option Step 2

  3. Click on the “Insert” and see what option is required in your data.


    Insert Option Step 3

  4. Now, click on the “Check Box” option. It enables us to create the checkbox in the sheet wherever required.


    Insert Option Step 4

  5. Next, click on the cell in the data where we want to insert the checkbox. The “Check Box (Form Control)” will appear nearby only to that place. If we need, we can adjust the box as per the requirement.


    Insert Option Step 5

  6. If we want to remove or edit the text on “Check Box 1,” which we created, right-click on the checkbox, select the text, and delete it or edit it as per the requirement. We can do one alternative: right-click the checkbox and select “Edit.”


    Insert Option Step 6

  7. Copy all the columns’ check-in by dragging the cell B1 checkbox to rest of the cells or press “Ctrl+D” to paste the same.


    Insert Option Step 7

  8. We can see that the same checkbox is shown in all the cells.


    Insert Option Step 8

  9. Now, we can easily use the checkbox by clicking on it, whether we have done the task.


    Insert Option Step 9

  10. If we want to delete the checkbox option from the worksheet, press the right-click, choose the cell, and press the “Delete” key.


    Insert Option Step 10

How To Add More Controls In Excel?

The steps to Add More Controls in Excel are as follows:

  • Step#1 - If you want to add more control in the insert tab, click on to more control option:
Add more Controls Step 1
  • Step#2 - When we click on more control, it opens the dialogue box, as shown below:
Add more Controls Step 2
  • Step#3 - Click on the control we want to add, and click OK. It will automatically show in the insert button excel tab.
Add more Controls Step 3

How To Format The Control Function In Your Excel Sheet?

The steps to format the Control Function in your Excel Sheet are as follows:

  • Step#1 - Select the control option which we have inserted in your Excel sheet:
Format the Control Step 1
  • Step#2 - Click right, and go to “Format Controls…”.
Format the Control Step 2
  • Step#3 - Once we click “Format Control”, it opens one dialog box, as shown below.
Format the Control Step 3
  • Step#4 - Go to “Color” and “Line” to choose the color and line of the box.
Format the Control Step 4
  • Step#5 - Click OK, we will get the color in the control option:
Format the Control Step 5

From the “Format” option, we can format the color and lines, size of the control, and protection of control (locked or lock the text) so that no one can change the option, object positioning, Alt Text, and control.

Important Things To Note

  • While inserting a button in Excel, we must always check which option is required in the data.
  • Always ensure that the inserted button is in an easily readable size.
  • We must always check to enable the “Developer” tab if it is allowed to insert a button in Excel.
  • We cannot adjust the size of the options button inside the control and its separation from its related content.
  • Do not oversize the control option while inserting a button in Excel.

Frequently Asked Questions (FAQs)

1

1. What is Macro used from the Developer Tab in Excel?

Arrow down filled
2

2. Why is the Insert Button In Excel not working?

Arrow down filled
3

3. How do you Add the Macro button to the Excel ribbon?

Arrow down filled