Method 1: Select a continuous region, through the "name box" to enter the address to select the cell, such as selecting the A3: A8 region of the A column, in the name box, enter "A3: A8" after the carriage return, you can select.

Method 2: select the cells to meet the conditions, such as selecting the A column of data cells greater than 5, by way of finding: ① select A column; ② CTRL + F to open the Find window; ③ find the contents of the input "*"; ④ "Find All "; ⑤ in the search box below, click on the" value "to find the data will be sorted according to the size of the value; ⑥ selected the first value is greater than 5 of the data, press shift, select the last data; ⑦ click on the" close ", at this point, the A column is selected This time, the data in column A is greater than 5 is selected.