excel隐藏行或者隐藏列的快捷键是什么?

如题所述

excel隐藏行或者隐藏列的快捷键是:Ctrl+数字9。
使用方法:

1、首先在excel表格中输入一组数据,需要将其中的数据行进行隐藏操作。
/iknow-pic.cdn.bcebos.com/0dd7912397dda1447171dbdbbcb7d0a20cf4865b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0dd7912397dda1447171dbdbbcb7d0a20cf4865b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/0dd7912397dda1447171dbdbbcb7d0a20cf4865b"/>
2、将需要隐藏的单元行选中,例如需要隐藏行3和行4。
/iknow-pic.cdn.bcebos.com/1e30e924b899a901c105ec5f13950a7b0208f5a3"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/1e30e924b899a901c105ec5f13950a7b0208f5a3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/1e30e924b899a901c105ec5f13950a7b0208f5a3"/>
3、然后按下键盘上的“Ctrl+数字9”,这两个按键的组合键为快捷隐藏键。
/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f8e5316b7fe1f3a292df578a4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f8e5316b7fe1f3a292df578a4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f8e5316b7fe1f3a292df578a4"/>
4、即可将行3和行4隐藏起来了。
/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5eb0d5c9d5fda81cb39db3d78"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5eb0d5c9d5fda81cb39db3d78?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5eb0d5c9d5fda81cb39db3d78"/>
5、如果需要将隐藏的单元格快捷展开,可以使用“Ctrl+Shift+数字9”快捷键,即可将隐藏的单元行展开了。
/iknow-pic.cdn.bcebos.com/b03533fa828ba61e8a877c464f34970a304e5969"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b03533fa828ba61e8a877c464f34970a304e5969?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b03533fa828ba61e8a877c464f34970a304e5969"/>
温馨提示:答案为网友推荐,仅供参考
相似回答
大家正在搜