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
Highlighted
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
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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies