AnswerBun.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!

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 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP