How does Excel filter work? Now, many people are using Office software. And in the face of a large data table, how to quickly display the required data? You will certainly consider this feature. So, how does Excel filter work? Below, small series to tell you about Excel more than 2013 pieces of the use of filtering.
① First, we open a data table to filter out the options for the amount greater than 400 in north China. Click the menu bar--Data--advanced.
Excel Filter
② The Advanced Filter dialog box, we select the result display, which is displayed in the original area, that is, the original data is not preserved. The following is shown in other locations, preserving the original data for easy comparison and viewing.
Excel Filter
③ List Area We choose A1:e9, which is the data area in the original table.
④ then is the selection of the criteria range, select G1:h2, and click OK.
Excel Filter
⑤ table data has changed, listing the options in North China that are greater than 400.