EXCEL里如何打印工资条.docxVIP

EXCEL里如何打印工资条第一行是标题行,工资条三个字,第二行为项目行,第三为内容,怎样之接打印出来呢?用宏的方法太复杂了,看不懂,在网上直接下载的有点不对,那位指点指点!设数据简略如图：?先将Sheet1表头复制后粘贴至Sheet2，如图：将公式=OFFSET(Sheet1!A$2,(MOD(ROW(),2)0)*INT(ROW()/2),0)粘贴至A3单元格，对准右下角，光标成“+”状时，按住左键向右拖，如图：??选中第二和第三行数据区域，对准右下角，光标成“+”状时按住左键向下拖，效果如图：如果要根据Sheet1表的数据自动将空值不显示，则可将公式=IF(ROW()COUNTA(Sheet1!$B:$B)*2-1,,Sheet1!A$2)粘贴至A2单元格，将公式=IF(ROW()COUNTA(Sheet1!$B:$B)*2-1,,OFFSET(Sheet1!A$2,(MOD(ROW(),2)0)*INT(ROW()/2),0))粘贴至A3单元格，方法同上，效果如图：添加数据，效果如图：daxie, food and extorting money. In June, Yu Qing Zhi get Japanese lived with three areas of intelligence troops quietly to Mao Ta Xiang, scattered