WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Insert Button in Excel

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 excel 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.

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

  • Step #2 – When you click on Option, it enables one dialogue box and goes to customize Ribbon in excel:

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

  • Step#5 – Now you will be able to 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?

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
You can download this Insert Button Excel Template here – Insert Button Excel Template
  • Step#1 – Select the data and organize the data as per the requirement.

Insert Option Step 1

  • Step#2 – Go to the Developer tab and select the insert option under the tab.

Insert Option Step 2

  • Step#3 – Click on the insert and see what option is required in your data:

Insert Option Step 3

  • Step#4 – Click on to checkbox option; it enables you to create the checkbox in your sheet where it is required:

Insert Option Step 4

  • Step#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

  • Step#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

  • Step#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

  • Step#8 – Now you will see the same checkbox will be shown in all the cells:

Insert Option Step 8

  • Step#9 – Now you can easily use the checkbox by click in checkbox if you have done the task or not:

Insert Option Step 9

  • Step#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.

Recommended Articles

This was a guide to Insert Button in Excel. Here 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 –

  • Creating a Dashboard in Excel
  • Remove Watermark in Excel
  • Excel Forms
  • Watermark in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Insert Button Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More