Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Screen Tips

  1. #1
    Guest

    Default

    How do I add screen tips to a worksheet? I don't have a hyperlink and I still want to add tips when the mouse is placed over column headings.

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure what you mean about the hyperlink, but if you look in the Excel help file for screentips, it should give you some information on it.

    I checked it in Excel 2000, and it doesn't mention anything about being able to use it for the column headings; just the buttons on the toolbars.
    Kristy

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're talking about tips for cells. You could use comments.

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Tennessee
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello:
    I'm not sure if this is what you are looking for or not, but if it helps:

    Click on a cell in your workbook, then click Data, Validation. Then select the Input Message tab. Add a Title and a message, and when a user clicks the cell they see what may as well be a tool tip. I don't think this will work for columns though.....

    FWIW

    Dave

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Louisiana USA
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think Waggy answered your question right. Click on the cell you want the tip in then choose insert from the main tool bar, click on comment then type in your tip. When ever a user holds the cursor over that cell the tip will display.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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