天气预报 > 其他 > 工资条如何打印
工资条如何打印
更新时间: 2020-10-28 00:00:00  

选中表格数据中的任意位置,然后点击菜单栏的‘数据’,再点击‘分类汇总’;接下来会弹出单元格,勾选‘每组数据分页’,点击确定;接下来数据就分开了;点击打印预览会只显示一个人的工资条;如果需要将汇总一行删除,选中任意一列,点击ctrl+G,然后选中‘空值’,点击确定;然后将鼠标放在选中的空值单元格,右击鼠标,点击删除;选中整行;点击确定即可。

关键词: 工资 如何 打印

工资条如何打印相关经验

天气预报

最新推荐

页面:/news/view-2464729/ | 耗时:0.1100 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2464729 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2464729 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2464729 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2324384,1079606,417641,2683582,1363790,2484366,2177796,111435,1083995,2822035,1924699,340841,1055081,2998660,2892438,107782,186134,1091954,859411,2431533,1478228,1342686,2050441,3209159,252101,641096,107279,2194908,109648,1097693) ORDER BY field (ArticleID,2324384,1079606,417641,2683582,1363790,2484366,2177796,111435,1083995,2822035,1924699,340841,1055081,2998660,2892438,107782,186134,1091954,859411,2431533,1478228,1342686,2050441,3209159,252101,641096,107279,2194908,109648,1097693)