1. Click the first line (which you need to filter), and then click Data, Sort, Filter and Filter. In this way, there is a little button that is pulled down in the first line.

2. click the filter arrow. Enter the information you need to search in the pop-up dialog box.

3. click ok.

if you need to search for other information, and the results of the second search and the results of the previous search need to be displayed at the same time, you can enter the information you want to search for the second time in the search box and check "Add current selection to filter".

the loan interest rate refers to the ratio of the interest amount to the principal amount during the loan period, which is managed by the People's Bank of China. The loan interest rate directly determines the distribution ratio of profits between borrowers and banks, thus affecting the economic interests of both borrowers and lenders. The loan interest rate varies with the types and duration of loans, and it is also related to the scarcity of borrowing funds. Choosing the appropriate loan amount is of great significance to the success or failure of your investment.