Select the data that meets the requirements in Excel 2007 for batch processing

① we open the Excel2007, select the Data table area, click the menu bar--Data--filter button.

② at this point the title line appears with a small triangular symbol, click the small triangle next to the data, eject the Drop-down menu, select the number filter--greater than.

③ in greater than 50, OK.

④ filter is complete, then enter 30 in cell G1, and copy it.

⑤ Select the D2:d4 area, press the F5 key, pop the positioning dialog box, and click on the Positioning Condition button.

⑥ in the Locate Condition dialog box, check the visible cells to determine.

⑦ then click the menu Bar--Start--paste selectively, tick, and OK.

⑧ so the previously copied content was added to complete the batch operation.

Classification:

• Excel Tutorials