The tutorial will teach you how to quickly add multiple checkboxes in Excel, change the check box name and formatting, as well as delete one, several or all checkboxes on a sheet. In last week's tutorial, we stared to discuss Excel Check Box and showed a few examples of to create a beautiful checklist, conditionally formatted To-Do list, interactive report and a dynamic chart responding to the checkbox state. Today, we will be focusing mostly on technicalities and how-to things. Of course, this information is not as exciting to learn as practical examples, but it will help you create and manage your Excel checkboxes in the most efficient manner.
When using checkboxes in Excel, you should distinguish between the check box name and caption name. The caption name is the text you see in a newly added checkbox such as Check Box 1. To change the caption name, right click the checkbox, select Edit Text in the context menu, and type the name you want.
![How How](https://cdn.ablebits.com/_img-blog/excel-name/excel-name-error.png)
When you first install Excel, it asks you for your name so it can personalize the registration for your program. It also writes your name into the user area. This information is used in various places by Excel, such as in the workbook properties area.
If you need to change your name, follow these steps:. Choose Options from the Tools menu. Excel displays the Options dialog box. Make sure the General tab is selected. (See Figure 1.) Figure 1. The General tab of the Options dialog box.
Change the information in the User Name box, as desired. Click on OK.