最佳答案:1、打开工资表。2、在有记录的信息后加一列序号,再复制两遍。3、把工资表头复制一遍,与信息数相等。4、全选,点击数据,排序。5、主要关键字以F列(就是我们加序号的那列),升序;次要关键字以E列(就是应
1、打开工资表。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvMGM3NjQ4ZThlZTI2NDY3ZTlhYjQwMWNkMDA1Y2U3NWU.jpg)
2、在有记录的信息后加一列序号,再复制两遍。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvYWI3ZmU5ZTRkNTQwNDA0OWI5NDk3MjJiNmZiMGNjMDg.jpg)
3、把工资表头复制一遍,与信息数相等。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvMGU1MDMyYzJjOGMwNGM2OTgxYTA2NTlhMTIzMTg5ZTE.jpg)
4、全选,点击数据,排序。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvNzdjNjdhZTQ4Y2FhNGQ2ZmEwOTkzYTZmOTM5MDhiNmI.jpg)
5、主要关键字以F列(就是我们加序号的那列),升序;次要关键字以E列(就是应发工资那列),点击确定。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvOWNkODE0N2VhMTI5NGZiOTljOTc5MjgxOGRlMWRiNzE.jpg)
6、工资表以表头加一条信息的样式排好了,后面也是111,222,333......,的排序。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvOGJlNDc4ZTk3ZDdlNDE0MWFkZmM3ZGE5NjM1MzNlNTU.jpg)
7、选中第一个工资信息,点击右边的边框,给第一条工资加框。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvZjljNjhiYjczZWFiNGJmNGI4NjYwNDVmODgyNmUyZDA.jpg)
8、选中工资信息加下面的空行,点击格式刷。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvYTg5OGQ2MmU4MTBmNGQwYzk3OWRhY2U5MDU2NWQwMTQ.jpg)
9、用格式刷选中下面的工资信息。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvYjJhNzlhZjg1YTc1NGYxMmE5YjI3YTgzMWRjMmY5NDM.jpg)
10、刷完之后,工资条制作完成。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlL3Rvcy1jbi1pLTAwMjIvZmNjNTVlMmRhMjdkNGFiNjlkYzAwOTY2ZWI2ZDRmMWI.jpg)