PasteFilter Support
PasteFilter filters an Excel worksheet column using a pasted list or visible selected cells. The current hosted version is a limited early-access release, not a Microsoft Marketplace listing.
Install or reopen
For initial installation, follow the early-access installation guide and upload the downloaded PasteFilter.xml through Excel's Upload My Add-in feature, if your account offers it. To reopen the pane, click Filter by List in the PasteFilter group on Excel's ribbon.
Basic use
- Select a populated cell inside the data column you want to filter. Your data should have a header row.
- Click Use selection to confirm the target column and range.
- Paste a list of values into the text box, or select cells and click Use visible cells. The faint grey numbers in an empty text box are only examples.
- Choose Include (show listed values) or Exclude (hide listed values). Click the green action button.
- To restore rows hidden by this column's filter, click Clear this column's filter.
Troubleshooting
- “Select a populated cell inside a data column with a header row.” Choose a nonempty data cell (not a blank outside the table), then click Use selection again.
- Unexpected or missing matches. PasteFilter compares displayed text. Check leading zeros, extra spaces, worksheet formatting, and whether values were actually entered (grey examples are placeholders).
- Nothing gets filtered. If none of your list items match, PasteFilter does not apply a filter. If only some match, it may ask for confirmation before applying the matched subset.
- Read-only or protected file. Excel may block filter changes. Try a small editable test copy and check with your administrator if needed.
- Stale interface or a resource error. Close and reopen the PasteFilter task pane and reload the workbook. Browser and Office caches can retain older task-pane files; if the issue continues, record the exact message and your browser/Excel version. Do not disable organization security controls.
- Missing Upload My Add-in. Your tenant or Excel version may restrict sideloading. Use Microsoft's test-install documentation or contact your Microsoft 365 administrator.
- Using a list from another workbook. Paste values into the task pane; direct cross-workbook range capture is not part of the tested workflow.
Remove a sideloaded add-in
Close the task pane. Look in Excel's add-in management interface for a removal option, if offered. For test installations, follow Microsoft's sideload removal guidance. Browser-local sideload storage may be removed when relevant browser site data is cleared, but this can also remove other browser data; do not clear storage indiscriminately.
Contact and reporting an issue
Email support@trendingatlas.com with: browser, Excel version, whether your account is personal or organizational, the step that failed, and the exact error message. Use dummy examples or redacted screenshots—do not share workbooks, sensitive data, document URLs, access tokens, or passwords.