Sunday, March 18, 2012

How to Make a Check Box in Excel


Display Developer Tab
1. Click the 'File' tab on the Ribbon and select 'Options' from the left panel.
2. Click 'Customize Ribbon' to display two panes.
3. Click the box next to 'Developer' to select it in the right pane. Click 'OK.'
Make Check Box
4. Click the 'Developer' tab on the ribbon.
5. Click 'Insert' and select the check box. A cross will appear on the screen.
6. Click and drag to insert a box with a check box and text. Select the text next to the check box, delete it and insert your own text.
7. Right-click the check box you created and select 'Format Control' to format it. You can modify colors and lines, change its size or add protection.

Blogger news