1. A

    Excel comments

    Hello, I have a problem with comment options in excel 2016. My idea is to add an excel file in Sharepoint page (shared with group of people) and to insert and reply a comments. I can only insert and edit a comment, but can`t reply to any of my co-workers comments. Can you please tell me what i...
  2. M

    Comments - Time & Date Stamp

    Hi, If someone can help me find a way to remove or hide the time and date stamp from 'comments' in Excel 365, it will be much appreciated. I am using the comments function to add regular updates to individual items in a workbook and am applying a date against each update in the comments field...
  3. D

    Automate FDF file generation, controlled by Excel VBA

    Folks, In the near future I will be coordinating the marking of 100s of exam scripts, submitted as PDF files from the students. One option being considered is the annotation of the PDF files with comments, which would be a direct extrapolation of ticks on a sheet of paper. I can generate an...
  4. K

    display the comments from referenced cell in cell of different sheet in same workbook

    I have a multi page work book and one of the sheets is for marking the status of personnel I reference their status in another sheet, but I would like not only that info to show but any comments that are attached to the referenced cell. Any ideas?
  5. C


    I am a middle school math teacher. I bought Power Excel (2019 edition) and was instantly overwhelmed. I am sure the book has the information to help me but I don't know what is called to do what I want. We have to post grades with comments 4 times a year. The list of comments we can use are...
  6. J

    Update summary worksheet comment with data from worksheets

    I am working with two workbooks. In the first workbook, I have a worksheet that lists 100 ip addresses. I have another workbook that has 100 tabs. Each tab matches one of the ip addresses that are on the first workbook. Also, each tab in the second workbook has anywhere from 10 to 30 rows of...
  7. S

    Excel Pivot Table "Insert Column"

    Hello, I have the results of a survey in an Excel spreadsheet, like this: <tbody> <tbody> Question </tbody> <tbody> Grade </tbody> <tbody> StrVal </tbody> <tbody> Flowers and Decoration Team </tbody> <tbody> -1 </tbody> <tbody> N/A </tbody> <tbody>...
  8. P

    Column Duplicate and Search

    Hello, I cant figure out how to do a "double search" in a column. Conditional formatting would be better but entering a formula along a row could do. Hopefully I can explain what I am tryin to do. I am trying to find duplicates within a column (F through S), then in the duplicate row see, if...
  9. T

    combine data from one column into one cell based on a criteria

    I have a column that has comments and I would like to combine those comments into one cell which =concat does but how can I add a comma and space between the comments from each line Column 1 = Topic Column 2 = Comment Not every row has a comment though Your help would be greatly appreciated
  10. K

    VBA CommentThreaded 'show'

    Hi, I would like to show a threaded comment (with notes it is straightforward, we put them on 'visible=true') when activating a sheet. Is there a line of code to show those threaded comments ? I noticed there is a "show comments" in review tab but recording macro does not help. Even if I add...
  11. P

    Automated copy without comments and certain rows

    Hello! I have a simple excel file from which I'd like to share just certain rows and no comments with my colleagues in a separate file stored on a common file area. I'm thinking about creating a copy that is automatically updated at least daily in which some of the rows and all of the...
  12. P

    Linking an Excel Snag List to the Comments in a Word File

    Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it. One of the guys is using an Excel file to create a snag list of issues...
  13. A

    Is there a better way to include comments than "Insert Comment"?

    So I've got a bunch of comments in a spreadsheet and all the comments are of variable length. I try not to change the size of the default box if I can avoid it cause I've noticed if I increase the size or move it, the next time I look at that comment, the box has changed size and I have to...
  14. L

    VBA to use activesheet selection in Transpose

    Hi I am using the built-in function Transpose to convert an array to a string and would like to use the current selection ie change this Comments = Join(Evaluate("TRANSPOSE('Base'!A1:A10 )"), vbNewLine) to Comments = Join(Evaluate("TRANSPOSE(Selection )"), vbNewLine) The latter gives a...
  15. K

    Import from second workbook plus some magic

    Good afternoon Guru's I'm racking my brain with the best way forward on this. I have two spreadsheets (similar examples attached), one holding source data and the second is used for reporting. The source data comes from another source and therefore doesn't contain comments (column G). The...
  16. A

    Formula to nullify value

    Hi There, I need help to generate excel formula for below table.I need to put comments "value Zero" if my column"A" value nullify. below is the table. Please help me to get formula for this. <tbody> value Abs Forumal Comments -400 400 Value zero for 400 -400 400 Value zero for 400 400...
  17. B

    Remove red indicators from notes excel 2016

    Hi! I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy. Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes...
  18. S

    Index/Match for Nonblanks

    Hello Everyone, I'm designing a sheet that is to be used as a tally for a strawman poll before a real vote is held on some projects being considered at my company. Some of these polls will have comments on them when returned. I'd like to list all comments, though most will be blank with no...
  19. J

    Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    Hello! I have a userform with two sections. There are 4 checkboxes in each section with the idea that they will be pre-populated comments that will fill into a textbox. I am able to get it to populate text into the textbox when one box is checked however the way I have it written only allows for...
  20. J

    VBA: When conditions are met, a message box will pop up

    Sheet1: <tbody> 1 Cat 2019-05-21 Error... This, this, and this 2 Dog 2019-05-21 Error. This, this, and this 3 Mouse 2019-05-25 In order - that, that, and that 4 Fish 2019-05-26 Where, when, why, and how </tbody> Sheet2: <tbody> 5 2019-05-22 Dog ... 6 2019-05-22 Fish ... 7...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back