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

How to use Office365 plus addressing?

1  Asked on December 8, 2020 by machiel-visser


Using rubber to rub contacts of RAM?

2  Asked on December 8, 2020 by alvin-wong


Problems with mixed 802.11b/g/n

1  Asked on December 7, 2020 by adam10603


Error building DRBD 9 from tarball on Oracle Linux 6

0  Asked on December 7, 2020 by christophorus-reyhan


multiple man arguments -> multiple files in less

0  Asked on December 6, 2020 by xdhmoore


Preserve SVG after PDF export from Word

0  Asked on December 6, 2020 by festus


Intel RST driver downgrade safely?

0  Asked on December 6, 2020 by legolas


Delay in starting command prompt

0  Asked on December 5, 2020 by batchcoding____s


Return to efi setup from grub commandline

1  Asked on December 5, 2020 by annoyinc


Ask a Question

Get help from others!

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