Question

excel如何向下输入序号1,1,2,2,3,3,4,4,5,5

1
1
2
2
3
3
4
4
5
5

Answer 1

就是说本单元格等于上上单元格+1

Answer 2

按下ctrl健，同时点下序号，往下拖动。

Answer 3

=INT(ROW(A2)/2)

Answer 4

=INT(ROW(A1)/3)+1
下拉公式

Answer 5

=INT(ROW(A2)/2)
下拉。