How to add comments to an Excel Worksheet cell如何添加評論到Excel工作細胞
Posted on April 6, 2008 at 5:34 am張貼於2008年4月6日在上午05時34分
I’ma big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets !我是大用戶的Excel和它總是amazes我如何少數人添加評論他們的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添加評論到Excel , ， working with comments工作與評論 , ， add comment to cell添加評論細胞 , ， add comment to worksheet添加評論工作 , ， add comment to workbook添加評論簿 , ， insert comments in cell插入評論在細胞
If you enjoyed this post, make sure you 如果您喜歡這個職位，請務必 subscribe to my RSS feed 訂閱我的RSS饋送 ! ！
» Filed Under »提交下 MS Office Tips的MS Office的秘訣
Related Posts相關文章
- 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
- How to add buttons to the Quick Launch toolbar in Windows如何將按鈕添加到快速啟動工具欄在Windows
- How to securely password protect an Excel file如何安全密碼保護Excel文件
sorry this blog is in english :S對不起，此博客是在英語： s
I want to print a sheet but not some cels我想打印一張，而不是一些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.喜DAV的，如果你要隱藏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.我的電腦是註冊darth vader ，所以每一次我“插入評論”的默認啟動了“ darth vader ： ”每一次我要選擇文本並刪除它之前加入我的評論。 It’sa pain, so any way to not have the user’s name inserted as a default would be quite helpful.這是疼痛，因此，以任何方式不會有用戶的名稱插入作為默認會相當有幫助。
Jonathan喬納森