Excel: How to show a floating text box only when I select the cell?

There's a type of text box in an Excel file that is associated with a cell and appears only when you select that cell uniquely (e.g., by clicking on it or moving to it with cursor keys).  Hovering over it doesn't do it; selecting it as part of a range doesn't do it.  It's somehow like a comment, only that cells with comments show a little red mark on the upper-right corner of the cell, and the comments appear when you hover over the cell.

What the worksheet normally looks like: no text box appearing:

What it looks like when the cell is selected: text box appears:

What are these text boxes called, and how do I make them?

1 Answer

That text box is a validation hint.

Use Data>Data Validation and enter a title and message on the Input Message tab:

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like