è§æ ·è¡¨æªå¾
æ¯å¦æ¯è¡ä¸æ两个空ç½è¡
A1è¾å ¥
=IF(MOD(ROW(A1)-1,3)=0,OFFSET($A$1,INT((ROW(A1)-1)/3),),"")
å ¬å¼ä¸æ
å¤å¶bå>å³é®>éæ©æ§ç²è´´>æ°å¼
å é¤Aåï¼OK.
å¦ææ³ä¸æ3è¡ï¼å°å ¬å¼ä¸ç3æ¹ä¸º4ï¼ä»¥æ¤ç±»æ¨ã
EXCEL如何快速插入多行