How do you create tick boxes on Microsoft excel?

As part of my friends coursework she needs to create tick boxes on microsoft excel. If people also know how do formulas on different pages that would help too.

How do you create tick boxes on Microsoft excel?
Make sure you have the "Forms" toolbar on by going to "View %26gt; Toolbars" and ensuring "Forms" has a tick next to it.





The forms toolbar in Excel will contain an icon that looks like a tickbox. Select that button and you can then literally draw the tickbox onto your spreadsheet wherever you want it.





To link it up to a cell, select your tickbox and right-click somewhere on it's border. Then go to "Format Control". On the "Control" tab there is a "Cell Link" field that allows you to link it up to a cell. Use the button at the right hand side of the field to select which cell you want to link the tickbox to.





To reference cells on different sheets (pages) in a formula, after the equals symbol write the name of the sheet followed by an exclamation mark, then the cell you want to reference.


For example:





=Sheet2!A1





The above references cell "A1" on "Sheet2".


Hope this helps.
Reply:You do not need a formula.


Use Marlett as the font type on the cells you want the tick marks to appear. (see where it says Arial or Times New Roman?- change it to Marlett)





To make a tick just type the letter A. For the X you need to type R.





Cheers!