Computer Science, asked by sravsveeru58, 2 days ago

Advanced filter steps pls

Answers

Answered by insiyasl2010
0

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.

Answered by bhavyapendeyala
0

Answer:

in the Advanced Filter dialog, select the list you want to filter. Click in Criteria range. Select the criteria, in this case G1 through H2. Click OK, and the range is filtered using the criteria.

Similar questions