你这个问题只有用VBA才能解决的,具体方法如下:1、在A1单元格输入起始数字,例如1。2、在A2单元格输入终止数字,例如79。3、右键点击左下角标签“Sheet1”,点击“查看代码(V)”。4、把下面一段代码拷贝到代码窗口。Private Sub Worksheet_SelectionChange(ByVal Target As Range)Dim a, b, c As IntegerDim j, k As Stringa = Range("a1").Valueb = Range("a2").ValueFor c = a To bj = c & ""k = k + j + ","N...