用Excel制工资条的两种简单方法.docVIP

如何快速制作工资条 下面介绍如何快速制作工资条。 方法/步骤1 1 运行你的工资表格，在工资条的右边备注上英文字母。 2 全选英文字母。 3 点击编辑里面的定位。 4 选择定位条件里面的空值后按确定。 5 在全选的阴影里点击右键里点击插入整行。 6 删除公司名称，复制整行的表头。 注：表头是不能用二个表格合并的哦。复制的时候一定要在左边数字2上点击。 7 全选左边的序列号。 注：复制的时候一定要在A上面点击。 ? 8 点击编辑里面的定位。 9 选择定位条件里面的空值后按确定。 10 在全选的阴影里点击右键选择粘贴就可以了。有了它，以后用?Excel表格做工资条就轻松多了。 ? END 注意事项 welding on a pipe iron, if it is necessary to weld on the device should be consent of the designers permission; D) when operating in electric welding, gas welding, isolation shall take the necessary measures to prevent damage to the cables, meters and other equipment at the bottom; E) in paint ... Security guard officers; I) after the installation of the equipment, shall promptly notify the follow-up process, construction units and the welding on a pipe iron, if it is necessary to weld on the device should be consent of the designers permission; D) when operating in electric welding, gas welding, isolation shall take the necessary measures to prevent damage to the cables, meters and other equipment at the bottom; E) in paint ... Security guard officers; I) after the installation of the equipment, shall promptly notify the follow-up process, construction units and the welding on a pipe iron, if it is necessary to weld on the device should be consent of the designers permission; D) when operating in electric welding, gas welding, isolation shall take the necessary measures to prevent damage to the cables, meters and other equipment at the bottom; E) in paint ... Security guard officers; I) after the installation of the equipment, shall promptly notify the follow-up process, construction units and the