How can I add active tick mark/check mark boxes in excel?

[gerberelli]

I would like to add a box that can be either checked or unchecked. I have
seen this in other spreadsheets but don't know how it's done.

 

[Mike H]

Try,

View|Toolbars|forms
Select a check box. Position cursor over the worksheet and drag to create it.

Mike

 

[Gord Dibben]

You can add checkboxes either through the Forms Toolbar or the Control Toolbox
Toolbar.

The Control Toolbox checkbox gives you more flexibility with formatting.


Gord Dibben MS Excel MVP