Excel怎么去除显示列号和列标?

发布网友 发布时间：2024-10-23 17:24

我来回答

共1个回答

热心网友 时间：4分钟前

Excel里插入表格显示列1，列2，去除的具体操作步骤如下：
1、首先在电脑桌面上点击打开“excel表格”，然后在此软件中打开要进行操作的文档，接着使用鼠标选中要进行操作的行和列。
/iknow-pic.cdn.bcebos.com/d62a6059252dd42a587fe01d0d3b5bb5c9eab816"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d62a6059252dd42a587fe01d0d3b5bb5c9eab816?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/d62a6059252dd42a587fe01d0d3b5bb5c9eab816"/>
2、然后在上方的选项卡内点击“设计”选项卡。

/iknow-pic.cdn.bcebos.com/4afbfbedab64034f6bc923b0a1c379310a551d7b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4afbfbedab64034f6bc923b0a1c379310a551d7b?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/4afbfbedab64034f6bc923b0a1c379310a551d7b"/>
3、然后在“设计”选项卡的下方点击“标题行”前方的勾，将其取消。

/iknow-pic.cdn.bcebos.com/dc54564e9258d10970834804df58ccbf6c814d20"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/dc54564e9258d10970834804df58ccbf6c814d20?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/dc54564e9258d10970834804df58ccbf6c814d20"/>
4、然后再查看刚选中的数据行和列的列1，列2已经去除了。

/iknow-pic.cdn.bcebos.com/79f0f736afc379311d6c679fe5c4b74543a9117b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/79f0f736afc379311d6c679fe5c4b74543a9117b?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/79f0f736afc379311d6c679fe5c4b74543a9117b"/>