How to add a Tooltip in Excel and Google Sheets

If you’d like to know how to add a tooltip in Excel and Google Sheets, then maintain studying this text. Each Microsoft Excel and Google Sheets enable including a tooltip to a cell worth to present readers a message concerning the info or info given in the cell.

Tooltips are small home windows that pop up when you choose or hover over a cell. Curiously, there may be a couple of means to show tooltips in spreadsheets. On this put up, we are going to present you ways to add a tooltip to a cell worth in each Microsoft Excel and Google Sheets.

How to add a Tooltip in Excel and Google Sheets

To show a tooltip, you could use Feedback, Notes, Knowledge Validation Assist Textual content, or Display screen Ideas. Allow us to see how they work in Excel and Google Sheets.

1] Including a Tooltip in Microsoft Excel

A] Including a Tooltip through Feedback

To add a tooltip in Excel by way of feedback, comply with the steps listed beneath:

1. Proper-click on the specified cell and choose Insert Remark. Alternatively, you’ll be able to choose the cell and press the Shift+F2 key mixture.
2. A textbox will seem. Write the textual content you’d like to present as a tooltip.
3. Click on wherever outdoors the cell.

A red-colored triangle on the top-right nook of the cell signifies that the remark has efficiently been added.

Notice: In Excel for Microsoft 365, the ‘comments’ function will enable you to provoke a dialogue utilizing a thread, whereas you should still add a easy annotation to the cell by way of the ‘notes’ function. Extra on this in the Google Sheets part.

B] Including a Tooltip through Knowledge Validation Enter Message

To add a tooltip in Excel by way of the Knowledge Validation Enter message, comply with the steps listed beneath:

1. Choose the specified cell.
2. Go to the Knowledge tab.
3. Within the Knowledge Instruments part, click on on the Knowledge Validation dropdown.
4. Choose the Knowledge Validation… possibility.
5. Within the Knowledge Validation window, change to the Enter Message tab.
6. Enter the textual content you need to show as a tooltip in the Enter message textbox.
7. Click on on the OK button.

The tooltip will seem when the cell is in focus.

C] Including a tooltip to hyperlinks through ScreenTip

Whenever you mouse hover on a hyperlink in MS Excel, it robotically exhibits a tooltip. If you’d like to add a customized tooltip to such hyperlinks, comply with the steps described beneath:

1.  Proper-click on the cell and choose the Edit Hyperlink… possibility.
2. Within the Edit Hyperlink window, click on on ScreenTip… button.
3. Enter the tooltip in the ScreenTip textual content textbox.
4. Click on on the OK button.

Your customized tooltip will now seem whenever you mouse hover on the cell, as an alternative of the default tooltip textual content.

2] Including a Tooltip in Google Sheets

A] Including a Tooltip through Notes

Notes enable you to connect an annotation with a cell worth in Google Sheets. This works comparable to the Feedback function in Excel. To add a tooltip to a cell worth in Google Sheets through notes, comply with these steps:

1. Choose the specified cell.
2. Proper-click on it and choose the Insert Notice possibility from the context menu.
3. Enter the tooltip in the textbox that seems.
4. Click on wherever outdoors the cell.

Subsequent time you hover over that cell, you will notice the tooltip.

Additionally Learn: How to Spotlight Duplicates in Google Sheets.

B] Including a Tooltip through Feedback

Feedback in Google Sheets is a extra complete function that enables a number of customers (that share the identical spreadsheet) to add their respective feedback on the identical cell worth. This creates a thread of feedback that can be utilized for discussions. The title and profile image of the consumer seems with every remark. If you’d like, you need to use feedback to add tooltips to cells in Google Sheets. Right here’s how to do it:

1. Proper-click on the specified cell and choose Remark.
2. Write the tooltip textual content.
3. Click on on the Remark button.

Now whenever you mouse hover on that cell, you will notice the tooltip. And when you choose the cell, it is possible for you to to add extra feedback to the thread.

C] Including a Tooltip through Knowledge Validation

Google Sheets allows you to show a tooltip upon coming into invalid knowledge in a explicit cell. To point out these tooltips, you’ve got to apply a knowledge validation rule to the cells.

1. Choose the specified cell (or a vary of cells).
2. Choose Knowledge validation from the Knowledge menu.
3. Set knowledge validation Standards. For instance, you’ll be able to set Date > Is legitimate date.
4. Choose Present warning in the On invalid knowledge subject (The Present warning possibility permits invalid enter in the cell however exhibits a warning message, whereas the Reject enter possibility rejects the invalid enter).
5.  Click on on the Save button.

Now when the consumer enters incorrect knowledge in the cell, a pink triangle will seem on the top-right nook of the cell. When he hovers over that cell, the tooltip message will probably be displayed.

Please be aware that the ‘Show validation help text’ function works in the case of the Reject enter possibility solely.

This beautiful a lot sums up alternative ways to add a Tooltip in Microsoft Excel and Google Sheets. Hope you discover this useful. Do share in the feedback if in case you have any queries.

How do I add a tooltip to an Excel spreadsheet?

There are a number of methods to add a tooltip in Microsoft Excel. The best is to choose the cell, right-click on it, and select the Insert Remark possibility. It’s possible you’ll then enter the tooltip textual content in the textbox that seems. The tooltip may also show the title related along with your Microsoft workplace profile. Other than this, you’ll be able to show a tooltip primarily based on knowledge validation, or show a display screen tip over a hyperlink as described in this put up.

How do you hover textual content in Google Sheets?

You may hove textual content in Google Sheets utilizing tooltips. You may add a tooltip in Google Sheets utilizing the built-in Feedback and Notes options. The Notes function permits you to show a easy annotation (or tooltip textual content) over a cell worth, whereas the Feedback function allows you to begin a dialog with different customers who share the identical spreadsheet. The distinction is, whenever you use Feedback to insert a tooltip, your title and profile image will probably be displayed together with the tooltip, whereas with Notes, nothing besides the tooltip textual content will probably be displayed.

Learn Subsequent: How to Export or Import Knowledge from Excel to Google Sheets.