Screen Tips

Mar 14th, 2002, 09:27 AM

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.

Von Pookie · Mar 14th, 2002, 10:08 AM

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.

waggy30 · Mar 14th, 2002, 10:15 AM

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

Dave · Mar 14th, 2002, 06:51 PM

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

Sam W · Mar 14th, 2002, 09:00 PM

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.

Mar 14th, 2002, 10:08 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 09:27 AM	#1
Guest Posts: n/a	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.

Mar 14th, 2002, 10:15 AM	#3
waggy30 New Member Join Date: Mar 2002 Location: England Posts: 46	If you're talking about tips for cells. You could use comments.

Mar 14th, 2002, 06:51 PM	#4
Dave New Member Join Date: Mar 2002 Location: Tennessee Posts: 25	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

Mar 14th, 2002, 09:00 PM	#5
Sam W New Member Join Date: Feb 2002 Location: Louisiana USA Posts: 26	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.