Thursday, June 16, 2011

How to Use a Cell in Excel As a Checkbox


1. In Excel, click 'File' from the menu bar.
2. Click 'Options' from the left pane. The 'Excel Options' window will open.
3. Click 'Customize Ribbon' from the left pane.
4. Check the box next to 'Developer' in the 'Customize the Ribbon' section on the screen's right side. Click 'OK.'
5. Switch to the 'Developer' ribbon.
6. Click 'Insert' from the 'Controls' tab.
7. Click the check box icon under 'form controls.' You cursor will turn into cross-hairs.
8. Click on the cell you want to change into a check box. A box will appear there.
9. Drag the check box to align it with the cell. Change the box's label, which is 'Check Box 1' by default.
10. With the check box still selected, click 'Properties' from the Developer ribbon's 'Controls' tab. The 'Format Control' window will open, with the 'Control' tab selected.
11. Enter the cell address in the 'Cell link' box. Click 'OK.'

Blogger news