不知道你是隐藏的单元格?工作簿?还是表呢?
一、单元格
1、选择数据区域;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a605913b9d9502534349b023bbaca?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、右键点击,在弹出框中选择设置单元格格式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d148c5b44296504fc2d46269a1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、进入后点击自定义,在类型中填写三个英文分号“;”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faf2b2119313b07e81836b4201d7912397dd8cb9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4点击确认数据就隐藏了,取消隐藏的话,把隐藏区域选择按照以上步骤做一次,将类型修改为“G/通用格式”就取消隐藏了;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b999a9014c086e0619c904010f087bf40ad1cb12?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、工作簿
1、右键点击工作簿;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7003af33a87e9507708c9261d385343fbf2b458?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击隐藏即可隐藏工作簿;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a901e0d7cf7a4773912b31bee4d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、取消隐藏则是在任意工作簿处点击取消隐藏即可;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a901ffe7df7a4773912b21beebc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、取消隐藏时可以选择取消那些工作簿,选择要取消的工作簿,点击确认即可;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5dd8b229f957bc6a7efce1b6269?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、表
1、选择点击视图选项卡;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4034970a304e251f0e23deb2aa86c9177e3e53a7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击隐藏即可隐藏表;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5fdf8db1cb1349548d8fd22e5b4e9258d0094ae2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、隐藏时候该取消隐藏按钮亮起,点击取消隐藏即可取消;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972b17222580ebcd7b899e510a5b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)