Deleting Controls (Checkboxes, Hidden, etc.) in Excel 2007

If you ever happened to copy web contents, such as tables or forms, into Excel (2007), you know it’s not straight-forward to delete the form controls, such as checkboxes, hidden fields, or edit controls.

The function to delete these controls is located in the Developer tab which may not be visible in the default installation.

To display the Developer tab, click on the Office Button (“Jewel”), select Excel Options, Popular, and check the “Show Developer tab in Ribbon” check box.

Once the Developer tab is visible and selected, enable “Design Mode”.

If you move the mouse over a checkbox or any other control in this mode, the cursor changes to a cross of 4 arrows, which allows you to select by clicking and then hitting the Delete key to delete.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: