How to insert a form in Microsoft Excel 2013?



Sometimes you would like obtain user feedback and use it as input in your Excel worksheet logic. Using form controls such as buttons, radio buttons, labels, check boxes, combo boxes, text-field labels etc’ allows you to capture information in an easy and intuitive way.

First off, you’ll need to enable the Excel 2013 Developer tab:

  • Select File menu and click on Options.
  • In the dialog box that opens, select Customize Ribbon.

1

  • Check Developer under the Main tab and click on OK.

Once you have enabled the Developer tab, you can go a head and create your custom form very easily.

  • Under the Developer tab, you will find an Insert option with which you can insert form controls.

2

  • Click on a form control and drop into your worksheet and you can build a form in Excel.
  • Then author your data entry form and assign it buttons, check boxes and other controls as required.
  • Your last action will be to either write custom macros or VBA code to automate form action as needed.

Join our tips and tricks newsletter

Like this post? Subscribe to our Newsletter and receive the latest productivity tips and tricks via email.



Bonus: Get free and instant access to our Office 2016 essentials course.

No spam guaranteed. Unsubscribe at any time.

Become a great Microsoft Office user!

Book5

Join our newsletter and get free and instant access to our Microsoft Office 2016 essentials course

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Leave a Comment: