Find answers to 3 common questions about visible results, clearing filters, and copying filtered data, plus a short glossary for key filter terms.
FAQ
How do I copy only visible cells after filtering?
- Apply the filter so that only the target rows remain visible.
- Select the visible data range and copy it.
- Paste the result and confirm that hidden rows are not included in the visible selection.
How do I clear a filter?
- Go back to the filter-related commands on the Data tab.
- Click Filter again, or use a related command such as Clear if available.
- Confirm that the previously hidden rows are shown again.
Does filtering delete the original data?
- No. Filtering only hides rows that do not match the current conditions.
- To restore the full view, clear the filter or remove the conditions.
- Check that all rows are visible again after the filter is removed.
Glossary
| Term | Definition |
|---|---|
| Filter | A way to show rows that match conditions and hide other rows temporarily. |
| Advanced Filter | A filtering method that uses a dialog box for more specific criteria. |
| Header drop-down arrow | The control that appears in a column header after filtering is enabled. |