EXCEL通常默认3个工作表,由于工作需要,有时我们需要使用多个工作表,增加工作表的方法比较多,版本不同,略有差异,现在的版本更方便些,下面以03版作说明:
右击任一工作表名,点击“插入”,再点“工作表”确定,就可插入一个新的空工作表;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/63d9f2d3572c11df7e09c17e652762d0f603c297?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/1ad5ad6eddc451da07b975b6b0fd5266d016321b?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/80cb39dbb6fd52665ae04549ad18972bd50736a7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
直接按Shift+F11功能键,也是插入工作表;
如果想插入的新工作表与现有的某个工作表格式相同,可以右击该工作表,“移动或复制工作表”,在出现的对话框中,勾选副本,重命名下工作表名即可;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d52a2834349b033b5930848713ce36d3d539bd36?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如果,希望打开的工作簿里不止3个工作表,可以通过工具--选项--常规--设置工作表数量,最多可以设置255个。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b6003dac74eaef50352ac65cb708?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)