How down four four filling

CodePudding user response:

Cell g1 to g4 input 3
Cell g5 ~ the g8 input=g1 + 1, and in turn=g2 + 1, g3 + 1==g4 + 1
And then select the g5 ~ the g8, move the mouse to select the right bottom corner of the area of the mouse into a black cross down

CodePudding user response:

Direct formula=INT ((ROW () - 1)/4) + 3

CodePudding user response:

refer to the second floor zara's reply:

direct formula=INT ((ROW () - 1)/4) + 3

If the filler text use formula to do? Don't support column,,,