Thursday, July 11, 2013

How to Insert a Tick Mark in Excel


1. Reveal the Developer tab, if necessary. In Excel 2007, click the 'Office' button and choose 'Excel Options.' In the Popular options set, check the box labeled 'Show Developer tab in the Ribbon.' In Excel 2010, click 'File' then 'Options.' Choose 'Customize Ribbon' in the Categories pane and check 'Developer' in the list of tabs.
2. Click the 'Developer' tab. Choose 'Insert' and from the Form Controls group choose the small box with a check mark in it.
3. Draw a box with the cursor to define the location and size of tick mark and its label. These remain changeable.
4. Click on the text, marked 'Check Box 1,' delete that text and add your own.
5. Right-click anywhere in the form and choose 'Format Control...' to set the form's formatting properties, such as color and lines. Choose the 'Control' tab to determine whether the box begins with a tick or without one. Add 3-D shading if you like.

Blogger news