Question

write steps for using advanced filters ?
give correct answers spam will be reported give fast ​

Answer 1

Answer:

• Select the entire data set (including the headers).
• Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q).
• In the Advanced Filter dialog box, use the following details: Action: Select the 'Copy to another location' option.
• Click OK.

Explanation:

Hope it will help you..

Answer 2

Answer:

Have a good now I answered u happy