Often you may want to add a tooltip to a cell in Excel so that a message will be displayed when you click on the cell.
Fortunately this is easy to do using the Data Validation feature on the Data tab along the top ribbon in Excel.
The following example shows how to use this feature to add a tooltip to a cell in practice.
Example: How to Add Tooltip to Cell in Excel
Suppose we have an Excel sheet in which we would like an employee at a grocery store to enter the total sales for the week in cell B1:
However, suppose we want a message to appear when the employee clicks in cell B1 to let them know that sales from the deli department should not be included in the total sales.
To create this tooltip, we can first click cell B1. Then, click the Data tab along the top ribbon, then click the Data Validation icon with the Data Tools group:
In the new window that appears, click the Input Message tab along the top.
Then type the following messages into the following boxes:
Title: Enter Total Sales
Input Message: Do not include sales from the deli department.
Then click OK.
Now, when you click on cell B1 a tooltip will automatically appear with the title and input message that you specified:
Note #1: You do not have to include a title for the tooltip.
Note #2: In this example we only created a tooltip for one cell, but you can create a tooltip for as many cells as you’d like in the spreadsheet.
The following tutorials explain how to perform other common operations in Excel: