Re: 一个关于excel的问题。# Windows - 看得见风景的窗口
m*g
1 楼
the easiest way is of course write a VBA macro for it. but if you
don't know, here is a workaround:
insert a new column, say A
start from the same row in colA where your data start, say A5, put 1 in A5,
and next row put = A5 +1, then autofill the remaining cells till it reaches
just one row before the 2nd picking point, say A104.
then copy and repaste the values ONLY of A5-A104.(paste special), and
then cp these values to the rest of the cells in colA till the end of your
data row.
now, select d
don't know, here is a workaround:
insert a new column, say A
start from the same row in colA where your data start, say A5, put 1 in A5,
and next row put = A5 +1, then autofill the remaining cells till it reaches
just one row before the 2nd picking point, say A104.
then copy and repaste the values ONLY of A5-A104.(paste special), and
then cp these values to the rest of the cells in colA till the end of your
data row.
now, select d