Multilevel Subtotal blank field fill in Excel

1. Using the scene, the multilevel subtotals, the blank in the summarized field, so that we directly take the value of the table brings very not (false image has 5,000 records, 1000 summary items)

2. Related techniques, indirect function, cell positioning function.
   1. Edit the INDIRECT function in any cell outside the data region, =indirect (ADDRESS (ROW () -1,column (), 4)), as

   2. First select the above to edit the function of the cell, and copy, then select the blank field to fill, and then the positioning operation, such as

   3. When you have selected a blank cell, press CTRL + V directly, as finished.
      

   4. 
      

Multilevel Subtotal blank field fill in Excel