If you want to spruce up the appearance of the check box, you can mark the option for 3-D Shading. Either enter the cell reference or click inside the Cell Link box and then select the cell on your sheet. Next, you can add a Cell Link if you want to attach the check box to a particular cell. Tip: The Mixed option is useful if you use VBA where you want the status of the check box to be neither checked (True) nor unchecked (False) until an action is taken. You’ll then see the Value options at the top to choose from for how you want the box to display. When the Format Control window opens, confirm that you’re on the Control tab. Right-click the check box control and choose “Format Control” from the menu. You can display the check box as checked, unchecked, or mixed as well as apply it to a particular cell and add shading. RELATED: How to Create a Basic Form in Microsoft Excel Format a Check Box in Excel

Click anywhere in the worksheet, and Excel will insert a checkbox at that location. Under Form Controls, click the checkbox icon (a square with a blue checkmark).

Click the box to check it and again to uncheck it. To add a checkbox: Go to the Developer tab on the ribbon. You can change that text by selecting it and typing the new text or by right-clicking the control and choosing “Edit Text.”Īnd there you go! You have a check box ready for use in Excel. Step 2: Click the File tab at the top-left corner of the window.When the check box pops onto your sheet, it includes a default name, Check Box 1. Once you have customized the ribbon to display the Developer tab, it will remain there for any other files that you open in Excel 2013. For example, this article will show you how to enable the Developer tab in Excel 2010. However, the steps are similar in other versions of Microsoft Excel as well. The steps in this article were written for Microsoft Excel 2013. How to Show the Developer Tab in Excel 2013 Fortunately this can be accomplished in just a few short steps by following our tutorial in the article below. This tab contains some useful tools, such as Macros, so many people will eventually need to enable it. For example, you could use an option on the Formulas tab to add a concatenate formula to your spreadsheet.īut there are tabs in Excel 2013 that are not included in the navigational ribbon by default, and the Developer tab is one of them.

Different settings and features are organized under appropriate tabs, allowing you to find the setting that you need to change. The navigational system in Microsoft Excel 2013 is based around a ribbon of tools and options at the top of the window.

How to insert developer tab in excel