contador web Saltar al contenido

How to create a checkbox in Excel | Productivity

Creating checkboxes in Excel is useful for objective question forms, where the user needs to select one of the standard answer options. The program also offers the option buttons option in the spreadsheets. While check boxes allow you to mark more than one item in the same question, option buttons have only one answer option.

READ: Microsoft 'copies' Chrome and launches browser that free

In the following tutorial, check out how to add checkboxes and option buttons to Excel spreadsheets. The procedure was performed in the latest version of Office 2016, but the tips are also valid for users of previous editions of the Microsoft program.

Learn how to add checkbox or option to forms in Excel Photo: Divulgao / MicrosoftLearn how to add checkbox or option to forms in Excel Photo: Divulgao / Microsoft

Learn how to add checkbox or option to forms in Excel Photo: Divulgao / Microsoft

Want to buy cell phones, TV and other discounted products? Meet Compare TechTudo

Step 1. Open the "File" menu and click on "Options" in the left sidebar;

Access Excel options Photo: Reproduo / Helito BeggioraAccess Excel options Photo: Reproduo / Helito Beggiora

Access Excel options Photo: Reproduo / Helito Beggiora

Step 2. In the Excel settings window, go to "Customize Ribbon". Check the "Developer" option and click "OK";

Activate developer options Foto: Reproduo / Helito BeggioraActivate developer options Foto: Reproduo / Helito Beggiora

Activate developer options Foto: Reproduo / Helito Beggiora

Step 3. Returning to the Excel spreadsheet, access the "Developer" tab and click Insert. In "Form Controls", click on the check box icon (square) or option button (circular);

Adding a checkbox or option Photo: Reproduo / Helito BeggioraAdding a checkbox or option Photo: Reproduo / Helito Beggiora

Adding a checkbox or option Photo: Reproduo / Helito Beggiora

Step 4. Now, click on the location where you want to add the item. Once this is done, edit the text that appears to the right of the selection box or option;

Adding an option box Photo: Reproduo / Helito BeggioraAdding an option box Photo: Reproduo / Helito Beggiora

Adding an option box Photo: Reproduo / Helito Beggiora

Step 5. To format, right-click on the item and, in the context menu, go to "Format control …";

Formatting checkbox or option Photo: Reproduction / Helito BeggioraFormatting checkbox or option Photo: Reproduction / Helito Beggiora

Formatting checkbox or option Photo: Reproduction / Helito Beggiora

Step 6. In the formatting settings, you can customize the colors and lines, size, text and more. After making the desired adjustments, press "OK" to apply the changes.

Formatting checkbox or option Photo: Reproduction / Helito BeggioraFormatting checkbox or option Photo: Reproduction / Helito Beggiora

Formatting checkbox or option Photo: Reproduction / Helito Beggiora

Which Excel formula to use for calculating savings? Ask your questions in the TechTudo Forum

How to delete all blank lines in Excel at once

How to delete all blank lines in Excel at once