Home

Adding Manual Notes Fields to Source Document

%3CLINGO-SUB%20id%3D%22lingo-sub-898062%22%20slang%3D%22en-US%22%3EAdding%20Manual%20Notes%20Fields%20to%20Source%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898062%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%20I%20am%20using%20Excel%20to%20track%20an%20event%20attendee%20list%20that%20is%20consistently%20being%20updated%2Fadded%20to%20by%20our%20marketing%20department.%26nbsp%3B%20I%20want%20to%20add%20custom%20notes%20fields%20to%20the%20document%20so%20we%20can%20add%20commentary%20to%20each%20record%20in%20the%20sheet%2C%20but%20I%20don't%20want%20that%20information%20to%20get%20blown%20out%20each%20time%20the%20attendee%20list%20is%20refreshed.%26nbsp%3B%20Is%20there%20a%20way%20to%20use%20Power%20Query%20to%20add%20editable%20fields%20to%20the%20original%20source%20document%20our%20marketing%20team%20is%20dropping%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-898062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%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-907024%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Manual%20Notes%20Fields%20to%20Source%20Document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421621%22%20target%3D%22_blank%22%3E%40MStewart1102%3C%2FA%3E%26nbsp%3BNo%20need%20for%20Power%20Query.%20There%20is%20an%20option%20to%20add%20a%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Finsert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ENote%3C%2FA%3E%20to%20a%20cell%2C%20which%20lets%20you%20add%20annotations%20about%20that%20particular%20row%20of%20data.%20There%20is%20also%20an%20option%20to%20add%20Threaded%20Comments%2C%20which%20let%20you%26nbsp%3B%40mention%20other%20people%2C%20and%20have%20a%20continuous%20conversation.%20Both%20stay%20with%20the%20cell%20you%20put%20them%20in%2C%20so%20no%20worries%20about%20sorting%20or%20filtering.%3C%2FP%3E%3C%2FLINGO-BODY%3E
MStewart1102
Occasional Visitor

Hi All, I am using Excel to track an event attendee list that is consistently being updated/added to by our marketing department.  I want to add custom notes fields to the document so we can add commentary to each record in the sheet, but I don't want that information to get blown out each time the attendee list is refreshed.  Is there a way to use Power Query to add editable fields to the original source document our marketing team is dropping?  

1 Reply

@MStewart1102 No need for Power Query. There is an option to add a Note to a cell, which lets you add annotations about that particular row of data. There is also an option to add Threaded Comments, which let you @mention other people, and have a continuous conversation. Both stay with the cell you put them in, so no worries about sorting or filtering.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies