How to hide tabs, cells, columns, and formulas in Excel如何隐藏标签，细胞，列和公式在Excel
Posted on September 17, 2008 at 5:29 am发布于2008年九月17日在上午05点29
Excel is the most common application I use in the office suite and there are many times when I need to hide thing in Excel: tabs, sheets, columns, cells, etc, etc for whatever reason. Excel中是最常见的应用我使用的办公套件，并有许多时候，我需要隐瞒的事情在Excel ：标签，表，列，细胞等，等不管出于什么原因。 In this article, I’ll go through a comprehensive list of items you can hide in Excel.在本文中，我去通过一个全面的项目清单，您可以隐藏在Excel 。
If you’re interested, you may also want to check out my previous article on如果您有兴趣，你也可以看看我以前的文章 how to hide text in Word如何隐藏在Word中的文字 . 。 Now let’s talk about all the stuff we can hide in Excel!现在让我们谈论的所有东西，我们可以隐藏在Excel中！
How to hide tabs/sheets in Excel如何隐藏标签/表在Excel
To hide a sheet or tab in Excel, right-click on the tab and choose Hide .要隐藏的工作表或标签在Excel中，右键单击标签，然后选择隐藏 。 Pretty easy eh?很简单吧？
Once hidden, you can right-click on a visible sheet and select Unhide .一旦隐藏的，您可以右击明显的资产负债表，并选择取消隐藏 。 All hidden sheets will be shown in a list and you can select the one you want to unhide.所有隐藏表将显示在列表中，你可以选择一个您要隐藏。
How to hide cells in Excel如何隐藏Excel单元格
Excel does not have the ability to hide cells in the traditional sense that they simply disappear until you unhide them, like with tabs I showed above. Excel不会有能力隐藏细胞传统意义上的，他们完全消失，直到您取消隐藏他们一样，用制表符我展示以上。 It can only blank out the cells so that it appears that nothing is in those cells, but it can’t truly “hide” them because of the fact that if you hide cells, what would you replace them with?它只能空出的细胞，以便它似乎没有在这些细胞，但它不能真正的“隐藏”他们，因为事实上，如果你隐藏细胞，你会取代它们？
If you greyed it out, you could easily tell there is something hidden, defeating the purpose of “hiding” them.如果你灰色了，你可以很容易地告诉有一些隐藏的，打败的目的， “藏”他们。 If you try to shift cells up and down, then when you unhide the hidden cells, where should everything shift?如果您尝试改变细胞的向上和向下，然后当你隐藏隐藏的细胞，而应该一切的转变？ You can hide entire rows and columns in Excel so they are not visible, but can only blank out individual cells.您可以隐藏整个行和列在Excel中，所以他们不可见，但只能空出单个细胞。 Here’s how.以下是如何。
Right-click on the group of cells and choose Format Cells .右击组的细胞，并选择单元格格式 。
On the Number tab, choose Custom at the bottom and in the Type box, enter three semicolons ( ;;; ), without the parenthesis.在数字选项卡 ，选择自定义的底部，并在输入框中，输入三个分号（ ; ; ; ） ，而括号内。
Click OK and now the data in those cells is hidden.单击确定，现在的数据，这些细胞是隐藏的。 To get it back, follow the above procedure, but choose the original format of the cells rather than Custom.要回来，按照上述程序，而是选择原始格式的细胞，而不是自定义。 Note that if you type anything into those cells, it will automatically be hidden and it’ll look like you didn’t type anything into it.请注意，如果您到任何类型的细胞，它会自动被隐藏，它会像你没有输入任何调查。 However, the original value in that cell will be replaced with what you typed.然而，原来的价值在细胞将取代您输入的内容。
How to hide rows and columns in Excel如何隐藏行和列在Excel
If you want to hide an entire row or column, select the row(s) and column(s), right-click and select Hide .如果要隐藏整个行或列，请选择该行（ s ）和列（星期日） ，点击右键并选择隐藏 。
To unhide a row or column, you need to select the row/column before and the row/column after the hidden row/column.要取消隐藏行或列，您需要选择行/列前，该行/列隐藏后，行/列。 For example, if Column B is hidden, to unhide it you would need to select column A and column C and then right-click and choose Unhide.例如，如果B栏被隐藏，取消隐藏，你将需要选择列A和C栏，然后点击右键并选择取消隐藏。
How to hide formulas in Excel如何隐藏在Excel公式
Hiding formulas is slight more complicated than hiding rows, columns, and tabs.隐藏公式略有复杂得多隐藏行，列，和标签。 If you want to hide a formula, you have to do TWO things: set the cells to Hidden and then protect the sheet.如果要隐藏的公式，你必须做两件事：建立细胞隐藏 ，然后保护工作表。
So, for example, I want to hide my sheet with the following secret formulas on them:因此，举例来说，我想隐藏我的资产负债表以下秘方他们：
First, I will select three cells in column D, right-click and choose Format Cells .首先，我将选择三个细胞D栏，右击并选择单元格格式 。 Now click on the Protection tab and check the box that says Hidden .现在点击保护标签，并选中该框隐藏称。
Note that this will not hide anything.请注意，这将不会隐藏任何东西。 You now have to click on the Review tab and then click on Protect Sheet .现在，您可以点击修改标签，然后按一下保护工作表 。
You can enter in a password if you want to prevent people from un-hiding the formulas.您可以输入一个密码，如果你想阻止人们取消隐藏公式。 Now you’ll notice that if you try to view the formulas (by pressing CTRL + ~ ), they will not be visible, however the results of that formula will remain visible.现在，你会发现，如果您尝试查看公式（ 按 CTRL + 〜 ） ，他们将不可见，但结果该公式将仍然可见。
I’m not sure why you would want to do this, but you can also click on the View tab and click on the Hide button under Split.我不知道你为什么会想这样做，但您也可以点击查看选项卡，然后按一下按钮下隐藏斯普利特。 This will hide the entire workbook in Excel!这将隐藏整个工作簿在Excel中！
So now you’ve learnt how to hide workbooks, sheets, rows, columns, cells, and formulas!所以，现在您已经学会如何隐藏工作簿，表，行，列，细胞，和公式！ That’s it.就是这样。 Enjoy!尽情享用吧！
» Filed Under »文章属于 MS Office Tips的MS Office秘诀
 Save this page 保存该网页 |  Stir it up on Mixx 它搅动了Mixx | |
 Add to Reddit 添加到Reddit |  Stumble this page 失败此页 |
Related Posts 有关职位
- How to use Data Validation in Microsoft Excel to create dropdown lists如何使用数据验证在Microsoft Excel中建立下拉列表
- Excel Tips & Tricks - How to unprotect only a portion of an Excel spreadsheet Excel的提示和技巧-如何取消只有部分的E xcel试算表
- How to securely password protect an Excel file如何安全密码保护的Excel文件
- Microsoft Excel Basics Tutorial - Learning how to use Excel Microsoft Excel中基础教程-学习如何使用E xcel
- How to hide text in MS Word 2007如何隐藏文本在MS Word 2007中
Pretty useful.相当有用的。
Thanks….谢谢... 。
I guess one could create a whole blog on Excel tips …it’s such a powerful and useful tool !我想一个可以创建一个整个博客Excel的秘诀...它是一个强大的和有用的工具！