Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
    – teylyn
    Commented Feb 13, 2019 at 22:50
  • Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cell A1, type Ctrl+C, click in cell B1, …, and then what?)?  If possible, post images (screenshots or photographs) in addition to a verbal description.  Please do not respond in comments; edit your question to make it clearer and more complete. Commented Feb 14, 2019 at 0:10
  • Are the worksheets or the workbook protected? Commented Feb 14, 2019 at 2:02
  • No the worksheets and workbook are not protected. Commented Feb 14, 2019 at 22:20