Question

We can again get the complete data back when we remove the filter ?​

Answer 1

Answer:

Clear or remove a filter

Excel for Microsoft 365 More...

If you can’t find specific data in a worksheet, it may be hidden by a filter. For example, if you have a column of dates in your worksheet, that column may have a filter that restricts the values to specific months.

There are several options:

Clear a filter from a specific column

Clear all filters

Remove all filters

Clear a filter from a column

Click the Filter Applied filter icon button next to the column heading, and then click Clear Filter from <"Column Name">.

For example, the figure below depicts an example of clearing the filter from the Country column.

Clear filter from button

Note: You can't remove filters from individual columns. Filters are either on for an entire range, or off. If you don't want someone to filter a particular column, you can consider hiding it.

Clear all the filters in a worksheet

Click the Data tab, and then click Clear.

Clear a filter button

Answer 2

Answer:

Remove filters from columns so you can view more or all of your data. ... Filters are either on for an entire range, or off.