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!

Related Questions

Disabling tab discarding in Google Chrome

2  Asked on November 24, 2021 by dvheld


Firewall on VirtualBox

1  Asked on November 24, 2021 by rbuckle


Up-cycling iMac Pro RAM

0  Asked on November 24, 2021 by workoverflow


Ryzen 9 Temperature Jumps

0  Asked on November 24, 2021 by yanbear


Run 2 commands when starting windows terminal

1  Asked on November 24, 2021 by matan-ben-moshe


Upgrade Linux Packages one by one

0  Asked on November 24, 2021 by wrench1815


Averaging time after converting to Seconds

1  Asked on November 24, 2021 by michaelm


Screen goes black randomly with HDMI Splitter

0  Asked on November 24, 2021 by user310148


What is the cURL command-line syntax to do a POST request?

7  Asked on November 22, 2021 by laurie-young


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP