天气预报15天查询> 其他> EXCEL中如何将隐藏的行删除

EXCEL中如何将隐藏的行删除

更新时间: 2020-09-21 00:00:00     

Excel中删除隐藏行可以通过解除隐藏后来删除:

1、打开Excel,找出隐藏行所在位置,如1行和3行之间;

2、按住ctrl鼠标单击1行和3行整行,右键弹出菜单,选择取消隐藏,2行就会解除隐藏模式;

3、选中需要删除的行右键选择剪切或者删除即可删除隐藏的行。

关键词: excel 如何 隐藏 删除

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-2758726/ | 耗时:0.6349 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2758726 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2758726 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2758726 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(997282,1110586,1054388,1103971,1103851,1061610,1066090,1071941,1069741,3027046,1062624,1099857,1047441,1073722,1093206,1067915,1066925,1070558,1112642,1085390,1052849,1094683,1082822,1091621,1108862,1089962,1100667,1067729,1081835,1050647) ORDER BY field (ArticleID,997282,1110586,1054388,1103971,1103851,1061610,1066090,1071941,1069741,3027046,1062624,1099857,1047441,1073722,1093206,1067915,1066925,1070558,1112642,1085390,1052849,1094683,1082822,1091621,1108862,1089962,1100667,1067729,1081835,1050647)