第一种方法就是使用Excel本身的显示比例功能来放大显示。如图,单击视图菜单,选择显示比例。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8389b504fc2d562d6bdc897e11190ef76c66c16?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选择自定义,你可以输入适当的比例,如300%,200%等,然后单击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93dfb46168d993df8dcd1005417?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
按现在的比例,可以清楚的看到局部,但无法一览全局。这时可以利用滚动条来解决问题。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e850352ac65c10387d0dd6b8b4119313b07e895c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
用鼠标拖动滚动条,可以左右移动,上下移动数据显示区域。
第二种方法。先用截图工具把全体数据所在区域截成一张图片,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a9d3fd1f4134970ab201085593cad1c8a7865d5d?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/ac345982b2b7d0a230fa1fe7cdef76094b369a9c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2.展示时我们用Windows照片查看器打开图片,通过放大图片,达到看清局部数据的目的。下图的放大镜工具可以调整显示比例。![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bec18781b9b292eb9389b506b2d?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/3bf33a87e950352aeaff3d725543fbf2b2118b29?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
时我们用Windows照片查看器打开图片,通过放大图片,达到看清局部数据的目的。下图的放大镜工具可以调整显示比例。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21bb051f8198618efdff7fe4ced2e738bd4e634?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)