Drag a corner, and when you see your checkbox display, release.īy default, the checkbox will have a label attached to it which you will not need for a basic checklist.
#Display developer tab in excel 2013 plus#
You’ll then see your cursor change to crosshairs (like a plus sign). Pick the “Checkbox” option in the “Form Controls” area. In the “”Controls” section of the ribbon, click the “Insert” button. Go to an item on your list and click the cell next to it where you want a checkbox. And this is where the Developer tab comes into the mix, so be sure to select that tab. The action part of a checklist is the checkbox. And you can, of course, add any row or column headers that you need. Even though you can always add or remove items later, this gives you the start you need to add your checkboxes. The best way to begin your checklist is to add the list items.
#Display developer tab in excel 2013 how to#
RELATED: How to Add the Developer Tab to the Microsoft Office Ribbon Add Your List of Items in Excel Then in the list below it, check the box next to the “Developer” option.Ĭlick “OK” and then close the Excel Options window. On the right side of the window, under “Customize the Ribbon,” make sure “Main Tabs” is selected. Alternatively, you can click File > Options > Customize Ribbon from the menu. Right-click anywhere on your Excel ribbon and select “Customize the Ribbon” from the drop-down list. If you don’t see this tab at the top of Excel, it takes only a minute to add it. Access the Developer Tabīefore you can use the check box form control in Microsoft Excel, you need to make sure that you have access to the Developer tab. With a simple check box form control, you can create a checklist for anything you like in Excel. Why a checklist? You might use a checklist for tracking items to pack for a trip, products for your company, a holiday gift list, monthly bills, or keeping track of tasks. Here’s how to create a checklist in your spreadsheet and make it look like your own. If you’re building a spreadsheet to share with others or simply one for your own tracking, using a checklist can make data entry a breeze in Microsoft Excel.
0 kommentar(er)
