How to add comments to an Excel Worksheet cell如何添加評論一個Excel工作表細胞
Posted on April 6, 2008 at 5:34 am發布於08年4月6日在上午05時三十四分
Make sure to read other posts from the Excel Tips series!請務必閱讀其他職位從Excel技巧系列！
- How to switch between worksheets in Excel如何切換在Excel工作表
- How to make a graph on excel如何使圖表上精益求精
- Microsoft Word: AutoText and AutoCorrect微軟Word ：自動和自動校正
- Master Excel Tables with AutoFilter and Subtotal碩士與Excel表格自動篩選和小計
- How to add comments to an Excel Worksheet cell如何添加評論一個Excel工作表細胞
- MS Excel Tips and Tricks – How to count things in Excel Excel的技巧與秘訣-如何計數的東西在E xcel
I’ma big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets !我是一個大用戶的Excel和它總是驚訝我怎麼少數人的意見，以增加他們的Excel電子表格 ！ Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet itself, thus saving you the time spent on the phone with colleagues!添加和使用Excel中的評論是一個偉大的方式來解釋公式，電池，數據和其他數據的電子表格本身，從而節省您的時間在電話上與同事！ It’s really easy to add comments to cells in Excel and I’ll explain how you can do so in Excel XP/2003 and Excel 2007.這真的很容易添加評論Excel單元格，我會解釋如何您可以在Excel XP/2003中和Excel 2007 。
Comments are basically notes that can be inserted into any cell in Excel.評論指出，基本上可插入任何細胞在Excel 。 It’s useful for reminders, notes for others, and for cross-referencing other workbooks.這是有益的提醒，注意到他人，並相互參照其他活頁簿。
How to add comments to a cell in Excel 2007如何添加評論細胞在Excel 2007
The first thing you’ll want to do is click on the cell where you want to insert the comment.的第一件事，你會想要做的就是按一下細胞在要插入評論。 In Excel 2007, you can add comments to a worksheet by going to the Review tab in the ribbon bar.在Excel 2007中，您可以添加評論到工作去修改標籤帶酒吧。
In the Comments group, click on New Comment .在評論組中，單擊新的評論。 In the Excel spreadsheet a comment text box will appear where you can type in your new comment.在Excel試算表評論文字方塊會出現在那裡，您可以輸入您的新評論。
Type in your comment and click outside of the text box when you are done.輸入您的意見，然後按一下以外的文字方塊當你做。 You’ll notice that there is a small red arrow at the top right of the cell, indicating that this cell has a comment.您會發現，有一個小小的紅色箭頭右上方的細胞，這表明此電池的評論。 Clicking on the cell automatically brings up the comment.點擊細胞自動帶來了評論。
How to add comments to a worksheet in Excel XP/2003如何添加評論工作在Excel XP/2003中
In Excel 2003 and XP, you have a couple of more options for inserting comments into a cell since there is no ribbon bar.在Excel 2003和XP中，您有幾個更多的選擇，插入評論進入細胞，因為沒有帶吧。 You can use the menus at the top, the mouse context-menu or the reviewing toolbar.您可以使用菜單上方，鼠標上下文菜單或工具欄的審查。
Add Comments Using Menu Bar新增評論使用菜單欄
First, you need to click on the cell that you want to insert the comment into.首先，你需要按一下電池，要插入到的評論。 Then click on the Insert menu option and choose Comment .然後單擊插入菜單上的選項，並選擇評論。
Just like in 2007, a text box will appear next to the cell where you can enter your comment.就像在2007年，一個文本框旁邊會出現細胞，您可以輸入您的評論。 Also, a red triangle appears at the upper right hand corner of the cell.此外，一個紅色的三角形出現在右上角的細胞。
Add Comments Using Mouse Context Menu新增評論使用鼠標上下文菜單
Another simple, yet nifty way to insert a comment into an Excel cell is to simply right-click on the cell and choose Insert Comment .另一種簡單，但漂亮的方式插入註釋到Excel細胞是只要右擊細胞，並選擇插入評論。 This actually works in both Excel 2007 and Excel 2003.這實際上工程在Excel 2007和Excel 2003中。
Add Comments Using Reviewing Toolbar新增評論使用審閱工具欄
Finally, you can use the Reviewing toolbar in Excel to add comments to cells.最後，您可以使用審閱工具欄在Excel中添加意見細胞。 To open the Reviewing toolbar, go to View, Toolbars, and choose Reviewing .要打開審閱工具欄，請前往查看，工具欄，並選擇審閱。
The first icon on the far left is the New Comment button.第一次上的圖示最左邊是新評論按鈕。 Click on it and a new comment box will appear in the currently selected cell.按一下它和一個新的評論框中將出現在目前選定的細胞。
That’s it!這樣就大功告成了！ You can also check out other options on the Reviewing toolbar to display/hide comment, delete comments, print comments and more.您也可以檢查出其他選擇的審閱工具欄顯示/隱藏評論，刪除評論，打印的意見和更多。 Have a question about comments, post a comment!有疑問的意見後評論！ Enjoy!盡情享用吧！
Technorati Tags: Technorati標記： add comments to excel添加評論精益求精 , ， working with comments工作的意見 , ， add comment to cell新增評論細胞 , ， add comment to worksheet新增評論工作 , ， add comment to workbook新增評論簿 , ， insert comments in cell插入細胞的評論
» 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 track changes in Excel 2007如何跟踪變化在Excel 2007
- How to hide tabs, cells, columns, and formulas in Excel如何隱藏標籤，細胞，列和公式在Excel
- How to use Data Validation in Microsoft Excel to create dropdown lists如何使用數據驗證在Microsoft Excel中建立下拉列表
- Microsoft Excel Basics Tutorial - Learning how to use Excel Microsoft Excel中基礎教程-學習如何使用E xcel
- How to add music to PowerPoint如何將音樂添加到的PowerPoint
sorry this blog is in english :S抱歉此博客是英文：小
I want to print a sheet but not some cels我想打印一張但一些細胞
how can I hide them?我怎麼能夠隱藏起來嗎？
Hi Dav, if you want to hide cells in Excel, select the cell range and then right click and choose Format Cells.您好戴維，如果您要隱藏Excel單元格，選擇單元格區域，然後點擊右鍵並選擇單元格格式。 Click on the Protection tab and then check off the Hidden box.點擊保護標籤，然後檢查了隱藏的方塊。 Now those cells will be hidden.現在，這些細胞將會隱藏。
You can also hide entire columns and rows by right clicking on the column headers (A,B,C,etc) and choosing Hide.您還可以隱藏整個列和行權的點擊欄標題（甲，乙，丙，等等） ，並選擇隱藏。 Hope that helps!希望幫助！
Anyone know if you can remove the registered user’s name from the comment box?任何人都知道你是否可以刪除註冊用戶的姓名從評論框？ My computer is registered to Darth Vader, so every time I “insert comment” the default starts out as “Darth Vader:” Each time I have to select that text and delete it before adding my comment.我的電腦是註冊達斯維達，所以我每次“插入評論”的默認啟動了為“達斯維德： ”每次我都選擇的文字和刪除它之前，我的意見。 It’sa pain, so any way to not have the user’s name inserted as a default would be quite helpful.這是一個痛苦，所以任何方式沒有用戶的名稱作為一個插入默認將是非常有益的。
Jonathan喬納森
Have a workbook with several worksheets.有一個工作簿與幾個工作。 Have one worksheet with many comments, some deliberately hidden & some showing.有一個工作有許多意見，一些有意隱藏和一些顯示。 Want to have a copy of the worksheet in the same file with none of the comments showing.希望有一份工作在同一個文件，沒有任何的評論顯示。 How do I do this without effecting the comment formatting of the original worksheet?我如何做到這一點不影響評論格式的原始工作？
Thanks for the tips on how to add comments on an Excel worksheet!謝謝您的提示如何新增評論Excel工作！