这种情况是由于excel水平滚动条被缩小或者在工作簿显示选项中没有勾选水平滚动条导致的,可以通过扩大水平滚动条或者在工作簿显示选项中勾选水平滚动条来恢复水平滚动条,具体操作步骤如下:
1、如果excel水平滚动条是被缩小导致不见的话,可以在右下角原本有水平滚动条的地方看到三个点,如图所示;
/iknow-pic.cdn.bcebos.com/6d81800a19d8bc3e6a88f7bd8c8ba61ea9d345c1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6d81800a19d8bc3e6a88f7bd8c8ba61ea9d345c1?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/6d81800a19d8bc3e6a88f7bd8c8ba61ea9d345c1"/>
2、将鼠标放在这三个点上面,按住鼠标左键往左拉到合适的位置即可;
/iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa13573699ba8f8c5494ee7b8a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa13573699ba8f8c5494ee7b8a?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/a6efce1b9d16fdfa13573699ba8f8c5494ee7b8a"/>
3、如果在excel右下角没有看到这三个点,那么代表在工作簿显示选项中没有勾选水平滚动条;
/iknow-pic.cdn.bcebos.com/d53f8794a4c27d1e2dbdcbb315d5ad6eddc4382a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d53f8794a4c27d1e2dbdcbb315d5ad6eddc4382a?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/d53f8794a4c27d1e2dbdcbb315d5ad6eddc4382a"/>
4、点击excel左上角的“文件”按钮;
/iknow-pic.cdn.bcebos.com/c8ea15ce36d3d539302efcb43487e950352ab0b2"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c8ea15ce36d3d539302efcb43487e950352ab0b2?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/c8ea15ce36d3d539302efcb43487e950352ab0b2"/>
5、然后点击左下角的“选项”按钮,进入excel选项设置页面;
/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a469d59784e6563f6246b60af4a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a469d59784e6563f6246b60af4a?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/0df3d7ca7bcb0a469d59784e6563f6246b60af4a"/>
6、在excel设置页面左侧可以看到“高级”选项,点击“高级”;
/iknow-pic.cdn.bcebos.com/ac6eddc451da81cb3c6070ba5c66d016082431c6"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/ac6eddc451da81cb3c6070ba5c66d016082431c6?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/ac6eddc451da81cb3c6070ba5c66d016082431c6"/>
7、在高级页面将页面往下拉,找到“此工作薄的显示选项”,然后将“显示水平滚动条”勾选;
/iknow-pic.cdn.bcebos.com/4b90f603738da9770b6d745cbe51f8198618e303"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4b90f603738da9770b6d745cbe51f8198618e303?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/4b90f603738da9770b6d745cbe51f8198618e303"/>
8、勾选“显示水平滚动条”之后点击确定,之后即可在excel右下角看到水平滚动条。
/iknow-pic.cdn.bcebos.com/8b13632762d0f703c6b468ab06fa513d2697c547"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8b13632762d0f703c6b468ab06fa513d2697c547?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/8b13632762d0f703c6b468ab06fa513d2697c547"/>