Text box formatting and text box hyperlinks

Hi,

I am putting a cover sheet on a spreadsheet I am putting together and I have a couple of questions I was hoping somebody could help me with.

First I am having trouble formatting the text in the box, I can't justify the text I can just pick left, right or centre aligned. Is there any way I can get it justified?

The second and more important part of the query regards hyperlinks within text boxes. I have two bullet points in the cover sheet and would like to insert a hyperlink in each line, the first to sheet 2 and the second to sheet 3. Something like the below


" > For info on Subject A, please see Sheet 2
> For info on Subject B, please see Sheet3 "


Is there a way I can do this where by the bold parts in the quotations are separate hyperlinks as so far my attempts to make hyperlinks in the text box have resulted in the whole text box becoming one big hyperlink.

All suggestions are welcome and thank you in advance for your help.

s.walsh87

Originally Posted by s.walsh87

Hi,

I am putting a cover sheet on a spreadsheet I am putting together and I have a couple of questions I was hoping somebody could help me with.

First I am having trouble formatting the text in the box, I can't justify the text I can just pick left, right or centre aligned. Is there any way I can get it justified?

The second and more important part of the query regards hyperlinks within text boxes. I have two bullet points in the cover sheet and would like to insert a hyperlink in each line, the first to sheet 2 and the second to sheet 3. Something like the below


" > For info on Subject A, please see Sheet 2
> For info on Subject B, please see Sheet3 "


Is there a way I can do this where by the bold parts in the quotations are separate hyperlinks as so far my attempts to make hyperlinks in the text box have resulted in the whole text box becoming one big hyperlink.

All suggestions are welcome and thank you in advance for your help.

s.walsh87

I don't know about the first part.

For the second part, what I have done is to put a smaller text box on top of the main text box. It should be transparent, and have no border, so it will be completely invisible.

Format the text you want to use in the main text box so that it looks like a hyperlink. (RGB color for hyperlinks is 0, 0, 255). Size the smaller text box so it just covers the text. Right-click the tiny text box, and add your hyperlink to it. In this way, the hyperlink is only associated with the word or phrase you choose, and not the entireity of the main text box. The hyperlink set up in this fashion will not change color once clicked. Even if you put the text in the tiny text box rather than showing through the text from the main text box, it won't fix the color change issue. Hyperlinks linked to text boxes just don't seem to work the same.