Select the checkbox and press Ctrl + C (to copy).This will place the new box at a location close to the previous checkbox, or Select the checkbox and press Ctrl + D (to duplicate and paste).To insert multiple checkboxes in Excel, insert the first checkbox. How to insert multiple checkboxes in Excel To remove the caption name text (Check Box 1): right click the checkbox, select Edit Text in the context menu, highlight the text, then delete. Your first box will have the default Caption Name “Check Box 1” next to the box as shown on the worksheet below.Įxcel also creates a Backend Name which is shown in the Name Box. Click anywhere in the worksheet, and Excel will insert a checkbox at that location.Under Form Controls, click the checkbox icon (a square with a blue checkmark).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |