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的秘訣...它是一個強大的和有用的工具！