Excel is more than just a tool for entering and sorting data. Did you know that it can be interactive too? Let’s walk through adding checkboxes to your spreadsheet.
For this exercise, you will want to be sure you have the Developer tab displayed. If you do not, click on File, Options, and Customize Ribbon. Then be sure to check the Developer option in the second column. Click OK.
Now, click on the cell where you want to add a checkbox and click the Developer tab. In the Controls section, click Insert and then select the checkbox option. Click on the cell again. You may need to reposition the box. You can rename the box or remove the text. Once the box is formatted the way you want, you can copy and paste it to other cells.
We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or an Excel tip that you would like to see, let me know, and I might feature it!
Billie Hardison
Director of Education & Training
BHardison@advocatecapital.com