Position the cursor to the lower right corner of the cell with the formula wait until it turns into the plus sign and then double-click the plus. You need to drag towards the right to apply the formula to the entire row. In cell A2 enter the formula.
Hold the left click of the mouse drag the mouse down to the end of the page.
Putting your cursor at the right-lower corner of the cell F2 till it becomes a small black cross. Select the column or row that you will work with in this case select the Column A and click Kutools More. Putting your cursor at the right-lower corner of the cell F2 till it becomes a small black cross. If its not in the top row it wont work.