Method of adding labels or text boxes to excel worksheets
First, understand labels and text boxes.
A label is text that identifies the function of a cell or text box or displays descriptive text, such as a title, description or short description. In addition, the label can also display descriptive pictures. In order to emphasize the text, when it is not feasible to merge cells or specific cell locations, labels can be used as flexible layout instructions.
A text box is a rectangular box in which you can view, enter or edit text or data bound to a cell. A text box can also be a static text field that displays read-only information. When you need to display a free-floating object, you can use a text box instead of entering text in a cell. You can also use text boxes to display or view text that is not bound by row and column boundaries, and to preserve the layout of the grid or datasheet in the worksheet.
Label (Form Control)
Label (ActiveX control)
Text box (ActiveX control)
Second, add labels (form controls)
What if? Develop tools? The tab is not displayed, please display it.
Are you online? Develop tools? On the account? Control? Group, click? Insert? , and then in? Form control? Click Next? Label?
.
Click where you want the label to appear in the upper left corner of the worksheet. To specify control properties, right-click the control, and then click? Format controls? .
Third, add tags (ActiveX controls)
What if? Develop tools? The tab is not displayed, please display it.
Are you online? Develop tools? On the account? Control? Group, click? Insert? , and then in? ActiveX control click next? Label?
.
Click where you want the label to appear in the upper left corner of the worksheet. To edit ActiveX controls, make sure you are in design mode. Are you online? Develop tools? On the account? Control? In the group, open? Design pattern? . Click where you want the label to appear in the upper left corner of the worksheet. To specify control properties, specify them in the? Develop tools? On the account? Control? Click in the group? Attribute? .
Tip: You can also right-click the label and click? Attribute? .
Fourth, add a text box (ActiveX control)
What if? Develop tools? The tab is not displayed, please display it.
Are you online? Develop tools? On the account? Control? Group, click? Insert? , and then in? ActiveX control click next? Text box?
.
Click the upper left corner of the text box in the worksheet where you want it to appear. To edit ActiveX controls, make sure you are in design mode. Are you online? Develop tools? On the account? Control? In the group, open? Design pattern? . To specify control properties, specify them in the? Develop tools? On the account? Control? Click in the group? Attribute? .
Tip: You can also right-click the text box and click? Attribute? .
Guess you like:
1.excel20 10 How to insert a text box?
2. How does 2.Excel insert a text box?
3. How does 3.Excel hyperlink to the specified worksheet?
4. How to rename the worksheet in Excel?
5. excel2007 Tutorial for Setting Hyperlink Worksheet