Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text in text box
I appear to be unable to bold text in a text box. What am I doing wrong?
I need to present a panel on my worksheet that will act as a 'help panel' and the text is such that it will scroll off screen. I think a text box is probably the easiest way to do this. If you have a better idea I would love to hear it! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text in text box
I assume that you are using an AxtiveX Text Box. (created from a button on
the Control Toolbox toolbar in pre 2007 versions of Excel or created from the ActiveX controls in xl2007) Click on the Design Mode button. This button looks like a blue set square with a ruler and a pencil. (On the Control Toolbox toolbar in pre 2007 or next to the Insert button on the Developer tab in xl2007) Right click on the text box and select properties. Click on the right column next to Font and then click on the button with the three little dots at the end of line and go from there. Don't forget to turn off design mode when you are finished. Regards, OssieMac "Mr. NoJoy" wrote: I appear to be unable to bold text in a text box. What am I doing wrong? I need to present a panel on my worksheet that will act as a 'help panel' and the text is such that it will scroll off screen. I think a text box is probably the easiest way to do this. If you have a better idea I would love to hear it! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text in text box
Thanks OssieMac - is there a way to just bold just the titles or is an all or
nothing scenario? "OssieMac" wrote: I assume that you are using an AxtiveX Text Box. (created from a button on the Control Toolbox toolbar in pre 2007 versions of Excel or created from the ActiveX controls in xl2007) Click on the Design Mode button. This button looks like a blue set square with a ruler and a pencil. (On the Control Toolbox toolbar in pre 2007 or next to the Insert button on the Developer tab in xl2007) Right click on the text box and select properties. Click on the right column next to Font and then click on the button with the three little dots at the end of line and go from there. Don't forget to turn off design mode when you are finished. Regards, OssieMac "Mr. NoJoy" wrote: I appear to be unable to bold text in a text box. What am I doing wrong? I need to present a panel on my worksheet that will act as a 'help panel' and the text is such that it will scroll off screen. I think a text box is probably the easiest way to do this. If you have a better idea I would love to hear it! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text in text box
Hi again,
I'm not sure that I am altogether clear on the purpose of the text box. If I understand correctly, it is simply instructions and/or messages to the user. If my understanding is correct, try using the Drawing Text Box. In pre xl2007 you will find it on the Drawing Toolbar and in xl2007 it is on the Insert Ribbon in the Text block at the right side of the ribbon. (The button looks like a printed sheet with an upper case A in the top left corner.) You can use all the usual text formatting tools for font type, bold and color etc in a Drawing Text Box. However, I am not aware of any method of returning values from them for use in the worksheet. Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
Activating wrap text format causes my text to disappear, why? | Excel Discussion (Misc queries) | |||
Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
Cond. format text color based on another's text color | Excel Discussion (Misc queries) |