SOLVED
Home

Embedded note

%3CLINGO-SUB%20id%3D%22lingo-sub-390840%22%20slang%3D%22en-US%22%3EEmbedded%20note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390840%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20note%20sure%20what%20to%20call%20this%20feature%20of%20excel%2C%20but%20an%20embedded%20note%20is%20the%20closest%20I%20can%20think%20of.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20inherited%20a%20spreadsheet%20(being%20used%20as%20a%20form%20for%20others%20to%20complete)%20and%20need%20to%20update%20it%20-%20it%20does%20not%20appear%20to%20be%20protected%20at%20all%2C%20or%20at%20least%20I%20think%20I%20have%20unprotected%20anything%20that%20was.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20certain%20cells%20in%20the%20sheet%20are%20clicked%20on%2C%20a%20yellow%20note%20appears%20(see%20screenshot).%26nbsp%3B%20It%20is%20not%20though%20a%20note%20in%20the%20sense%20that%20there%20is%20a%20small%20red%20triangle%20and%20a%20text%20box%20that%20can%20be%20clicked%20on%20to%20edit%20the%20note%20-%20these%20just%20appear%20and%20cannot%20be%20edited%20at%20all.%26nbsp%3B%20%26nbsp%3BIt%20is%20some%20sort%20of%20embedded%20instruction%20that%20is%20now%20out%20of%20date%20or%20plain%20wrong.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20find%20any%20way%20to%20'un-embed'%20or%20'unlock'%20these%20notes%20though%20-%20I%20can%20change%20the%20text%20and%20formatting%20of%20a%20cell%2C%20but%20the%20note%20does%20not%20alter.%26nbsp%3B%20I%20can%20copy%20and%20paste%20the%20cells%2C%20and%20the%20note%20goes%20with%20it%20(unless%20I%20use%20paste%20special%20and%20only%20paste%20the%20text%2C%20but%20then%20that%20means%20I%20have%20to%20reformat%20the%20entire%20thing!).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20knew%20what%20this%20feature%20was%20called%20I%20would%20be%20able%20to%20look%20it%20up%20to%20find%20the%20solution.%26nbsp%3B%20But%20I%20can't%20find%20a%20name%20and%20I%20can't%20find%20any%20way%20to%20remove%20or%20edit%20these%20notes.%26nbsp%3B%20Help!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100529i80A596780A5E280B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Embeded%20note%20excel.PNG%22%20title%3D%22Embeded%20note%20excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-390840%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-390899%22%20slang%3D%22en-US%22%3ERe%3A%20Embedded%20note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F310560%22%20target%3D%22_blank%22%3E%40Alastair77%3C%2FA%3E%26nbsp%3B%2C%20for%20the%20Brexit%20other%20people%20who%20are%20paid%20for%20that%20shall%20find%20simple%20answers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390888%22%20slang%3D%22en-US%22%3ERe%3A%20Embedded%20note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390888%22%20slang%3D%22en-US%22%3EAh%20ha!%20Hero!%20Thank%20you%20sir!%20With%20simple%20answers%20like%20this%20can%20you%20take%20over%20Brexit%20for%20us%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390856%22%20slang%3D%22en-US%22%3ERe%3A%20Embedded%20note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390856%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F310560%22%20target%3D%22_blank%22%3E%40Alastair77%3C%2FA%3E%26nbsp%3B%2C%20stay%20on%20cell%2C%20Data-%26gt%3BData%20validation-%26gt%3BData%20validation-%26gt%3BInput%20message.%20Here%20remove%20or%20change%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Alastair77
New Contributor

I am note sure what to call this feature of excel, but an embedded note is the closest I can think of.  

 

I have inherited a spreadsheet (being used as a form for others to complete) and need to update it - it does not appear to be protected at all, or at least I think I have unprotected anything that was.

 

When certain cells in the sheet are clicked on, a yellow note appears (see screenshot).  It is not though a note in the sense that there is a small red triangle and a text box that can be clicked on to edit the note - these just appear and cannot be edited at all.   It is some sort of embedded instruction that is now out of date or plain wrong. 

 

I cannot find any way to 'un-embed' or 'unlock' these notes though - I can change the text and formatting of a cell, but the note does not alter.  I can copy and paste the cells, and the note goes with it (unless I use paste special and only paste the text, but then that means I have to reformat the entire thing!).

 

If I knew what this feature was called I would be able to look it up to find the solution.  But I can't find a name and I can't find any way to remove or edit these notes.  Help!Embeded note excel.PNG

3 Replies
Highlighted
Solution

@Alastair77 , stay on cell, Data->Data validation->Data validation->Input message. Here remove or change it.

Ah ha! Hero! Thank you sir! With simple answers like this can you take over Brexit for us? :-)

@Alastair77 , for the Brexit other people who are paid for that shall find simple answers

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies