Right-click on the checkbox > select Format Control. Click where you want the checkbox to appear. From the pop-up menu, select the checkbox icon in the Form Control section. To insert a checkbox, click the Developer tab > click the Insert icon in the Controls section. Once you can see the tab Developer, the following instructions work for all three versions: Select Popular in the left pane> check the Show Developer tab in the Ribbon checkbox.

If you are using Excel 2007, click the Office sphere in the upper left corner> click the Excel Options button near the bottom right corner of the resulting pop-up box. Make sure the list on the right is titled Main Tabs (1). To make it visible in Excel 2010 or 2013, click the File tab > select Options > click Customize Ribbon. Unfortunately, that tab is hidden by default. You can insert check boxes on the Excel Developer tab. Then, use the formula with the function = isblank () to make the contents of that cell affect the rest of the spreadsheet.īut if you want more friendly spreadsheets - especially if you're designing spreadsheets for many others, use the technique below ( tested in Excel 2007, 20 ). To select it, just type x (or any other character). If you are compiling a spreadsheet for yourself, you simply need to leave a blank box for this purpose.

Checkbox for excel 2010