=A2&","&B2&","&C2&","&D2&","&E2&","&F2
EXCEL表格里的公式,要下拉到每一行,但表格又超长,怎么快速拉完?
先复制公式,然后选择需要粘贴公式的第一个单元格,按shift键不松,选择这行或列的最后一个单元格,然后右击粘贴
解决excel中日期为何变成了数字问题?
=TEXT(B4,"YYYY-M-D")
=A2&","&B2&","&C2&","&D2&","&E2&","&F2
EXCEL表格里的公式,要下拉到每一行,但表格又超长,怎么快速拉完?
先复制公式,然后选择需要粘贴公式的第一个单元格,按shift键不松,选择这行或列的最后一个单元格,然后右击粘贴
解决excel中日期为何变成了数字问题?
=TEXT(B4,"YYYY-M-D")