By Knowing how to make checkboxes in Excel 2011 for Mac is a handy bit of know-how. Check boxes appear in all kinds of forms, such as surveys and questionnaires, where you choose from multiple answers. In Excel 2011 for Mac, each check box control is linked to a cell on your worksheet. To make a check box in Excel 2011 for Mac, take these steps:. While your form is unprotected, click the Check Box control on the Developer tab of the Ribbon.
Drag diagonally and then let go of the mouse. A check box appears and is selected on your worksheet. Right-click the new button and choose Format Control from the pop-up menu. On the Control tab of the Format control dialog, set a cell link by clicking into the empty Cell Link field and then clicking a cell on any worksheet. The linked cell is indicated in the Cell Link field in the dialog. Unlock the linked cell. The control won’t work when you protect the worksheet unless you unlock the linked cell.
Adjust other formatting options as desired. Repeat Steps 1 through 4 for each Check Box control you want to add to your worksheet.
To prevent a user from tabbing into a linked cell, put the linked cell in a hidden row or column, or on another worksheet. Click OK to close the Format Control dialog. When the check box control is selected, the linked cell’s value is TRUE. When the control is deselected, the linked cell’s value is FALSE.
You can set the initial value in the Format Control dialog. If you choose an initial setting of Mixed, the linked cell’s value displays #N/A until the check box is clicked in the form. The default text when you make a check box is its official name, which will be something like Check Box 4. Change the default text by clicking into the text inside the control and then dragging over the text to select it. Then type replacement text. Typing replacement text to display does not change the control’s name.
Before adding the checkbox, make sure that you prepare and finalize the list of items in your check-list. Once the check-list is ready, you can follow the steps to Insert Checkbox in Excel. To insert checkbox in Excel, click on the Developer tab and select the Check Box option. How to Insert a Checkbox in Excel Inserting a checkbox in Excel is an easy task, the checkbox control is available in the Excel developer tools option. Checkbox and other controls like drop downs can be quite helpful while designing forms in Excel.
Word for Office 365 for Mac Word 2019 for Mac Word 2016 for Mac With Word you can create two kinds of checklists:. Lists with boxes or check marks instead of bullets or numbers. Use boxes if you plan to print the list and check off each item you complete. Lists you can check off in Word. This involves adding a content control from the Developer tab, but you don't need to be a developer to do it.
Replace bullets or numbers with check marks or boxes You can replace the bullets or numbers that mark each item in a list with another symbol that you choose, such as a box that you can check on a printed version of your document. The symbol that you chose will be added to the Bullet Library so it'll be handy if you want to use it again for another list. To replace bullets or numbers with boxes for check marks. Select the entire list. The bullets or numbers won’t look selected.
Click Home, and then click the arrow next to Bullets. If you don’t see a check mark or check box you want in the Bullet Library, click Define New Bullet. Click Bullet, and choose a symbol from the table of symbols. For more choices, in the Font box choose a symbol font, such as Wingdings. Scroll through the list of symbols and select the symbol you want to use, such as an open box ( ) or a three-dimensional box ( ). Click OK, and then click OK again in the Customize Bulleted list dialog box.
Make a checklist you can check off in Word To create check boxes that you can check off in Word, add content controls for check boxes to your document. Step 1: Show the Developer tab The first step is to configure Word to display the Developer tab. If this tab is already visible in Word, you can skip the following procedure. To display the Developer tab in Word.
On the Word menu, click Preferences. In Word Preferences, click View.
Near the bottom of the View dialog box, select Show developer tab, and then click OK. Step 2: Make your list Unlike formatting a list with bullets or numbers, you add check boxes individually to each list item. Tip: If you add a Tab character between a check box and the text in a list item, you can format the list item with hanging indentation, like Word applies to bulleted lists. Hanging indentation is covered in. The following procedure describes adding check boxes as you create the list; the second describes adding check boxes to an existing list.
To add check boxes to list items as you create the list. Click the Developer tab, and then click Check Box. If you want white space after the check box, press the Tab key or the Spacebar. Type the first item in your list, and click Enter. Repeat steps 1 through 3 for each item in your list. To add check boxes to an existing list.
Place the cursor at the start of the first list item. Click the Developer tab, and then click Check Box. If you want white space after the check box, press the Tab key or the Spacebar. Select the check box and any Tab characters or spaces that you added after the check box, and then copy the selected characters by pressing Command-C.
Place the cursor at the start of the next list item, and then paste the copied check box and characters by pressing Command-V. Repeat Step 5 for each remaining item in your list. Step 3: Refine the layout If some of the items in your list are more than one line long, you can use hanging indentation to align them. To apply hanging indentation to a list. Select the list.
On the Format menu, click Paragraph. Under Indentation, type 0.25 in the Left box. In the Special list, click Hanging. For By, Word sets a default value of 0.5 inches.