Insert Button in Excel

How to Insert Button in Excel

Buttons in excel are single-click commands which are inserted to perform certain task for us, buttons are used in macros and it can be inserted by enabling developer’s 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 more we can find button tab to insert a button and then we draw the button on the worksheet, normally the button is in design mode but after coding we can remove it and use it.

While using the insert option, first, you need to insert the developer option in your excel ribbon.

Insert Button in Excel

Steps to Insert Developer Option in Excel Ribbon

  • Step #1 – Go to file option and click on the option at the bottom of the file option:
Insert Button Step 1
Insert Button Step 2
  • Step #3 – Now, you will be able to see so many options under the customize ribbon tab; click on the checkbox adjacent to the developer, which enables the developer option in your Excel ribbon:
Insert Button Step 3
  • Step #4 – When you check the developer option, click Ok to confirm the same:
Insert Button Step 4
Insert Button Step 5

How to Make use of Insert Button Option in Excel?

Excel Insert button is used if you want to add the control in your documents, for e.g., checkbox, scroll button, etc.

You can download this Insert Button Excel Template here – Insert Button Excel Template

Below are the steps of using insert button option in excel –

  1. Select the data and organize the data as per the requirement.

    Insert Option Step 1

  2. 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. Click on to checkbox option; it enables you to create the checkbox in your sheet where it is required:

    Insert Option Step 4

  5. Click in the cell in your data where you want to insert the checkbox in your data. The CheckBox control will appear nearby to that place only; if you want, you can adjust the box as per your requirement.

    Insert Option Step 5

  6. If you want to remove or edit the text on Check Box 1 which was created, just right click on the checkbox and select the text and delete it or edit as per the requirement. You can do one alternative thing as well, just click right on the checkbox and select Edit.

    Insert Option Step 6

  7. Copy the check-in all the columns by dragging the Column B1 checkbox to all the tabs or press Ctrl+D to paste the same in cells.

    Insert Option Step 7

  8. Now you will see the same checkbox will be shown in all the cells:

    Insert Option Step 8

  9. Now you can easily use the checkbox by click in checkbox if you have done the task or not:

    Insert Option Step 9

  10. If you want to delete the checkbox option from your worksheet, press right click and choose the cell and press delete.

    Insert Option Step 10

How to add more Controls in Excel?

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

How to Format the Control Function in your Excel Sheet?

  • Step#1 – Select the control option which you 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 you click on format control, it opens one dialogue box, as shown below:
Format the Control Step 3
  • Step#4 – Go to color and lines to choose the color and line of your box.
Format the Control Step 4
  • Step#5 – Click Ok, you will get the color in your control option:
Format the Control Step 5

From the format option, you can format the color and lines, size of the control, protect of control (Locked or lock the text) so that no one can change the option, object positioning Alt Text and Control.

Things to Remember

  1. While inserting a button in excel, always check which option is required in your data.
  2. Always make sure that control should be of a size that is easily readable while inserting a button in excel.
  3. While inserting a button in excel, you can only add only one checkbox or the options button at a time.
  4. To make it faster, once you add your first control, just click right and select Copy and Paste the control option.
  5. Always check to enable the Developer tab if it was enabled to insert a button in excel.
  6. The size of the options button inside the control and its separation from its related content can’t be adjusted.
  7. Don’t oversize the control option while inserting a button in excel.
  8. While adding a button, always make sure to text, and the size of the button should be almost the same.
  9. Don’t use the line of box thick because it will not be able to see what is shown in the button.
  10. While inserting a button in excel, always remember to make your control option feasible so that everyone can understand the same and able to find the information in your excel sheet useful.

This was guide to Insert Button in ExcelHere we discuss how to Insert the Form Control Button in Excel along with practical examples and downloadable templates.  You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *