SPECIALIST TRAINING
How to create checkboxes in Microsoft Excel
Being able to effectively organise and display data in a compact and easy to read manner can be difficult. However, Microsft Excel provides an easy to use feature to allow you to implement check boxes as opposed to displaying large quantities of data and in turn making it much easier to understand.
How to add a checkbox
Firstly, right click anywhere in the blank space within any tab of the main Excel nav bar and select customise ribbon.
This will open Excel options, under customise ribbon, check the developer checkbox.
Doing so will give a new tab on the main Excel nav bar called Developer.
Now that is enabled, to add a check box, go to insert under the developer tab/form controls and select checkbox. Once selected, click anywhere on your worksheet to add it to the workspace.
This will have added a check box to your worksheet and can be manipulated however you wish.
SPECIALIST TRAINING