TransWikia.com

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

Super User Asked by tinylid on November 1, 2020

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?

One 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

Correct answer by FlexYourData on November 1, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP