下载PDF文件下载PDF文件
X
How.com.vn是一个“多人协作写作系统”,因此我们的很多文章都是由多位作者共同创作的。 为了创作这篇文章,志愿作者多次对文章进行了编辑和改进。
这篇文章已经被读过47,847次。
用户有时候会隐藏 Microsoft Excel 中的列来使工作表显示的内容更加简洁,或者用来防止特定数据被更改或删除。但是这些隐藏的行和列都可以随时显示出来。按照下列步骤操作,你就可以学会在所有 Excel 版本中显示隐藏的列。
步骤
小提示
- 如果你想要将工作表中所有的隐藏列显示出来,那么你可以点击“选择全部”按钮,该按钮位于列“A”左侧和行“1”上方,是一个空白矩形框。然后再根据本文中后续步骤进行操作。
- 如果在尝试上述步骤后有一些列还是无法显示,这可能是由于其列宽设置为“0”或很小数值。因此需要增加这些列的列宽,具体方法是将光标放置在这些列的右边框附近,然后拖拽鼠标增加其列宽。
- 如果你想要显示 Excel 表格中隐藏列“A”,你可以通过在位于公式工具条左侧的“名称框”中输入“A1”来选择隐藏列。然后再根据本文中后续步骤进行操作来显示列“A”。
广告
这篇文章对你有帮助吗?
⚠️ Disclaimer:
Content from Wiki How 中文 language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
广告