To align it with cell gridlines, hold down ALT while you drag the control.Ģ.Resize the control. When you finish modifying the control, click Exit Design Mode. Set whether changes to the underlying cells affect the control To change how the control is resized or moved when the cells underneath it are resized or moved, right-click the control, click Format Control, and then click the Properties tab. To retain the proportions of the control, hold down SHIFT while you drag a corner sizing handle. Resize the control Drag one of the sizing handles: To align it with cell gridlines, hold down ALT while you drag the control. Move the control Drag it to another location. If the shortcut menu contains the command Assign Macro, the control is a Forms toolbar control.īased on the type of control you are working with, do one of the following:ĭisplay the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox. If no shortcut menu appears or the shortcut menu contains the command Properties, the control is an ActiveX control. Microsoft Excel has two different types of controls that you move and resize in different ways:ĪctiveX controls, and controls from the Forms toolbar.ĭetermine which type of control you have: right-click the control you want to change. I have office XP and I found this in the Help File (not sure if it's the same in Office 2K).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |