SOLVED

Excel yellow label that i cant seem to edit

%3CLINGO-SUB%20id%3D%22lingo-sub-2953827%22%20slang%3D%22en-US%22%3EExcel%20yellow%20label%20that%20i%20cant%20seem%20to%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2953827%22%20slang%3D%22en-US%22%3E%3CP%3EAll%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20this%20yellow%20box%20and%20why%20cant%20I%20edit%20it%3F%26nbsp%3B%20I'm%20using%20a%20Microsoft%20Excel%20template%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIve%20tried%20selecting%20it%20and%20nothing%20happens%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hsduk101_2-1636622470842.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326252i04503FF6E4B1B4BE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hsduk101_2-1636622470842.png%22%20alt%3D%22hsduk101_2-1636622470842.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2953827%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2953936%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20yellow%20label%20that%20i%20cant%20seem%20to%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2953936%22%20slang%3D%22en-US%22%3ETo%20me%20it%20seems%20like%20a%20data%20validation%20input%20message.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20remove%20it%2C%20go%20to%20the%20data%20tab%2C%20select%20data%20validation%2C%20then%20there%20is%20a%20tab%20in%20the%20middle%20named%20'input%20message'%20and%20unselect%20'show%20input%20message%20when%20cell%20is%20selected'.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20(hopefully)%20should%20remove%20this%20yellow%20box%3C%2FLINGO-BODY%3E
New Contributor

All,

 

What is this yellow box and why cant I edit it?  I'm using a Microsoft Excel template

 

Ive tried selecting it and nothing happens

 

hsduk101_2-1636622470842.png

 

 

 

2 Replies
best response confirmed by hsduk101 (New Contributor)
Solution
To me it seems like a data validation input message.

To remove it, go to the data tab, select data validation, then there is a tab in the middle named 'input message' and unselect 'show input message when cell is selected'.

This (hopefully) should remove this yellow box
Beccaleck
Thank you it was a data validation message and I have now been anle to edit it
Many Thanks
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE