Skip to search results
PRODUCT
Office.com results
Add, edit, find, and delete rows by using a data form
Article When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. What do you want to ...
Excel 2007
Edit text in a control on a worksheet
Article You can edit the text that is displayed in a Form control or ActiveX control, such as a label or help information, and you can edit the alternative text descrip...
Excel 2007
Add or register an ActiveX control
Article In addition to the various Form controls, your computer contains many ActiveX controls installed by Microsoft Office Excel and other programs, such as Calendar ...
Excel 2007
Position and size a control with its underlying cell on a worksheet
Article At times, you may want a control to act independently of its underlying cell (the cell which contains the upper leftmost corner of the control). At other times,...
Excel 2007
Add a list box or combo box to a worksheet
Article You use a list box or a combo box, which are similar but slightly different controls, to let users make multiple choices of items or to enter their own value in...
Excel 2007
Protect controls and linked cells on a worksheet
Article You may want to add protection to Form controls and ActiveX controls to prevent users from moving, changing, or deleting controls. If one or more controls is an...
Excel 2007
Print a control on a worksheet
Article You may want to print a control because it contains data or images that you want to include on a printed document. If one or more controls is an ActiveX control...
Excel 2007
Add a scroll bar or spin button to a worksheet
Article You use a scroll bar or spin button to quickly enter or change a range of values. What do you want to do? Learn about scroll bars and spin buttons Add a scroll ...
Excel 2007
Add a label or text box to a worksheet
Article Show All Hide All You use a label and a text box together for basic data entry. What do you want to do? Learn about labels and text boxes Add a label (Form cont...
Excel 2007
Resize or format a control on a worksheet
Article To create a professional looking appearance for a worksheet form, you should provide a consistent format to all controls and objects, and size them appropriatel...
Excel 2007
Select or deselect controls on a worksheet
Article To work with controls on a worksheet form — for example, to group, copy, resize, or format them — you must first select the controls or cancel the selection. Th...
Excel 2007
Delete controls on a worksheet
Article If one or more controls is an ActiveX control, do the following: Make sure that the Developer tab is available. Display the Developer tab Click the Microso...
Excel 2007
What can I do if I can't see or edit a cell because a control or object covers it?
Article Symptom Form controls, ActiveX controls, and other controls or objects obscure cells, which makes it difficult to see or edit the values in those cells. Cause M...
Excel 2007
Group, copy, move, or align controls on a worksheet
Article After you add Form and ActiveX controls to a worksheet form, you may want to group, copy, move, or align controls to create a well designed, user friendly for...
Excel 2007
Add a button and assign a macro to it in a worksheet
Article To run a macro, you can add a button to your worksheet and then assign the macro to it.
Excel 2007
Why can't I select form and ActiveX controls?
Article Symptoms Selecting a control is sometimes difficult and unpredictable. Cause There can be several reasons for this: Because a Form control can contain text or o...
Excel 2007
Overview of forms, Form controls, and ActiveX controls on a worksheet
Article Create, edit, format, lock, and unlock Excel 2007 forms, including data forms, worksheets that contain Form and ActiveX controls, and VBA UserForms.
Excel 2007
Add or edit a macro for a control on a worksheet
Article For forms and ActiveX controls , you can do the following: Perform an action or operation when a user clicks a form control by assigning a macro to it. Run...
Excel 2007
Add a group box or frame control to a worksheet
Article Show All Hide All You can use a group box or a frame control to group related controls (such as option buttons, check boxes, or closely related contents) into o...
Excel 2007
Why are form-related commands or controls on the ribbon disabled?
Article Symptoms You try to add a Form control or an ActiveX control to your worksheet, but the commands in the Controls group on the Developer tab or a specific c...
Excel 2007
Didn't find what you were looking for?Search all of Office.com