Is it possible to highlight the text in a Textbox of Excel 2013? (rather than copy the highlighted text in MS Word to Excel's Textbox)

Question

Dear all,

May I know is it possible to highlight the text in a Textbox of Excel 2013?

If I selected the text within a Textbox which I'd like to highlight, then I client "HOME" -> "Font" -> "Fill Colour"; the background colour of the whole Textbox (rather than the selected text) being highlighted.

But when I copied the text in MS Word (which has already been highlighted in Word) and then paste to Excel Textbox (with Paste Option being "Keep Source Formatting"); I am able to have the highlighted text in the Textbox of Excel.

Hence I believe that it is possible to highlight text right in a Textbox of Excel but just I am not able to pick out where is such option.

For highlighted text in a Textbox, what I mean is:

Thank you so much for you help!!!

Answer 1

I came up with something similar to what you are looking for. I played around with the Textbox, and I found that you can add "Glow" which can be formatted to look similar to Word highlighting. The way that I did this was as follows:

1. Add text box: Format-->Insert Shapes-->Insert Text Box
2. Format Text Box: Select the text box-->Format-->WordArt Styles-->Format Text Effects:Text Box (Dialog Box)-->Text Options-->Text Effects-->Glow. I set the color to Yellow and the transparency to 0%.

Answer 2

Dear James.

Thanks a lot!

I have searched through the "All commands" in the QAT and it seems that the "Text Highlight" feature in MS Word is not a built-in function in MS Excel Text Box (Other than copy the highlighted text from MS Word to Excel Text Box).

Hope that Microsoft would add this as a built-in feature to the next version of Excel.

Thanks again and it is just a perfect alternative for highlighting text in Excel Text Box! =D

Answer 3

I just spent 30 minutes trying to remember how I did this before so I'm putting this here in hopes that I and others find it in the future. 

If you would like to have certain words highlighted, I found that you can:

(1) use MS Word to write the word and highlight the text (colors are limited though)

(2) copy the text

(3) paste the text into the Excel text box and select Keep Source Formatting from the paste options drop down menu

Answer 4

I just spent 30 minutes trying to remember how I did this before so I'm putting this here in hopes that I and others find it in the future. 

If you would like to have certain words highlighted, I found that you can:

(1) use MS Word to write the word and highlight the text (colors are limited though)

(2) copy the text

(3) paste the text into the Excel text box and select Keep Source Formatting from the paste options drop down menu