How to Insert Button in Excel

The buttons in Excel are single-click commands inserted to perform a certain task for us. They are used in macros:

  • We can insert it by enabling the “Developer” tab.In the “Insert” form controls in excelForm Controls In ExcelExcel Form Controls are objects which can be inserted at any place in the worksheet to work with data and handle the data as specified. These controls are compatible with excel and can create a drop-down list in excel, list boxes, spinners, checkboxes, scroll bars.read more we can find button tab to insert.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

  • Step #1 – We must first go to the “File” option and click on the “Options” at the bottom of the file option. option:

  • Step #2 – When we click on “Options,” it enables one dialog box and goes to “Customize Ribbon in excelRibbon In ExcelRibbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more:

  • Step #3 – Now, we will be able to 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:

  • Step #4 – When we check the developer option, click Ok to confirm the same:

  • Step#5 – Now we will be able to see the developer tab in you excel ribbonDeveloper Tab In You Excel RibbonEnabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. This tab is disabled by default on excel; thus, the user needs to enable it first from the options menu.read more option as shown below:

How to Make use of Insert Button Option in Excel?

Excel “Insert” button is used if we want to add the control in the documents. E.g., checkbox, scroll button, etc.

How to add more Controls in Excel?

  • Step#1 – If you want to add more control in the insert tab, click on to more control option:

  • Step#2 – When we click on more control, it opens the dialogue box, as shown below:

  • Step#3 – Click on the control which we want to add and click Ok, It will automatically show in the insert button excel tab.

How to Format the Control Function in your Excel Sheet?

  • Step#1 – Select the control option which we have inserted in your excel sheet:

  • Step#2 – Click right and go to format controls:

  • Step#3 – Once we click on “Format Control,” it opens one dialog box, as shown below.

  • Step#4 – Go to “Color” and “Line” to choose the color and line of the box.

  • Step#5 – Click Ok, we will get the color in the control option:

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

  • We must select the data first and organize the data as per the requirement. Then, go to the “Developer” tab and select the “Insert” option under the tab. Click on the “Insert” and see what option is required in your data. Now, click on the “Check Box” option. It enables us to create the checkbox in the sheet wherever required Next, click on the cell in the data where we want to insert the checkbox. The “CheckBox (Form Control)”will appear nearby only to that place. If we need, we can adjust the box as per the requirement. 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 on the checkbox and select “Edit.” Copy all the columns’ check-in by dragging the “Column B1” checkbox to all the tabs or press “Ctrl+D” to paste the same in cells. We can see that the same checkbox is shown in all the cells. Now, we can easily use the checkbox by clicking on it, whether we have done the task.  If we want to delete the checkbox option from the worksheet, press the right-click, choose the cell, and press the “Delete” key.

Things to Remember

  • While inserting a button in Excel, we must always check which option is required in the data.Always ensure that the control is of a size that is easily readable while inserting a button in Excel.While inserting a button in Excel, we can only add one checkbox or the options button at a time.Once we add the first control, click right and select “Copy” and “Paste” the control option to make it faster.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.While adding a button, always ensure to text and the button’s size should be almost the same.We should not use the thick line for the box because it will not be able to see what is shown on the button.While inserting a button in Excel, we must always remember to make the control option feasible so that everyone can understand the same and find the information in the Excel sheet useful.

This article is a guide to Insert Button in Excel. Here, we discuss inserting the form control button in Excel, practical examples, and downloadable templates. You may learn more about Excel from the following articles: –

  • Creating a Dashboard in ExcelRemove Watermark in ExcelExcel FormsWatermark in Excel