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乔纳森