+ Reply to Thread
Results 1 to 2 of 2

Text box formatting and text box hyperlinks

  1. #1
    Registered User
    Join Date
    05-31-2010
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    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

  2. #2
    Registered User
    Join Date
    05-07-2012
    Location
    Norristown, PA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Text box formatting and text box hyperlinks

    Quote Originally Posted by s.walsh87 View Post
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1