1. We take the Vlookup function as an example to illustrate the filling of the spreadsheet.
2. The result to be found here is: the title of the book.
3. Enter the insert function Vlookup and fill in the parameters of the response. Here, you can see that the first cell is filled with the corresponding book name. What you need to do is fill in the following cells.
4. Place the mouse in the lower right corner of the cell until a "ten" sign appears, and then double-click the "+"sign to fill in the last line.
5, or put the mouse in the cell "+",double-click and drop this button until the end, and then you can fill it in at the end.
6. If the cell is calculated by a formula, it can also be filled according to the previous method.
7. First calculate the value in the first cell, and then fill in the following cells.