我是Excel的大用户,我总是惊讶于很少有人在他们的 Excel 电子表格中添加评论(add comments to their Excel spreadsheets)!在Excel(Excel)中添加和使用注释是解释电子表格本身中的公式、单元格和其他数据的好方法,从而节省您与同事通电话的时间!在Excel(Excel)中向单元格添加注释非常容易,我将解释如何在Excel XP/2003、Excel 2007、Excel 2010和Excel 2013中执行此操作。
注释基本上是可以插入Excel中任何单元格的注释。它对于提醒、其他人的笔记以及交叉引用其他工作簿很有用。请注意,较新版本的 Office在“评论”工具栏中有一个名为(Comments)“显示墨水(Show Ink)”的选项,这仅对平板电脑有用。该功能基本上可以让您手写评论而不是输入评论。但是,在台式机和笔记本电脑上,它仅对查看在平板电脑上创建的手写评论有用。
此外,一旦将注释添加到工作表中,您还可以对注释执行许多其他操作,例如格式化、更改形状、调整大小等。滚动(Scroll)到帖子底部以获取这些提示。
向 Excel 2013 单元格添加注释
Excel 2013 看起来与 2010 有点不同,但总体而言几乎相同。要添加评论,请单击“评论”选项卡,然后(Review tab and click)在选择所需的单元格后单击“新评论”。(New Comment)
现在只需输入您的评论,当您离开该单元格时,您会在单元格的右上角(right corner)看到一个小的红色三角形,表示该单元格有评论。
向 Excel 2010 单元格添加注释
在Excel 2010中,添加评论非常简单,与 2013 相同。只需单击(Just click)“审阅”选项卡(Review tab),您就会看到所有评论工具。单击(Click)要添加评论的单元格,然后单击新评论(New Comment)。
将出现一个小对话框窗口(dialog window),您可以在其中开始输入文本。您还会注意到单元格右上角的红色小三角形,它表示该单元格有评论。
您可以通过单击“显示所有评论”(Show All Comments)按钮快速查看工作表上的所有评论。如果工作表有一堆评论,这会派上用场。您也可以单击“上一个(Previous)”和“下(Next)一个”来逐一循环浏览所有评论。
向 Excel 2007 单元格添加注释
Excel 2007的过程与上述相同。您要做的第一件事是单击要插入评论的单元格。单击(Click)功能区栏中(ribbon bar)的“ 审阅”(Review)选项卡以查看评论编辑(comment editing)工具。
在评论(Comments)组中,单击新评论(New Comment)。在Excel电子表格中,将出现一个注释文本框(comment text box),您可以在其中输入新注释。
输入您的评论并在完成后单击文本框(text box)外部。您会注意到单元格的右上角有一个红色的小箭头,表示该单元格有注释。单击单元格会自动显示评论。
(Add Comments)向 Excel XP/2003 Cell添加注释
在Excel 2003和 XP 中,由于没有功能区栏(ribbon bar),因此您有更多选项可将注释插入单元格。您可以使用顶部的菜单、鼠标上下文菜单(mouse context-menu)或审阅工具栏。
使用菜单栏添加评论
首先,您需要单击要插入评论的单元格。然后单击Insert菜单选项并选择Comment。
就像在 2007 年一样,您可以在其中输入评论的单元格旁边会出现一个文本框。(text box)此外,单元格的右上角(hand corner)会出现一个红色三角形。
使用鼠标上下文菜单添加评论(Add Comments Using Mouse Context Menu)
将注释插入Excel 单元格(Excel cell)的另一种简单而巧妙的方法是只需右键单击该单元格并选择Insert Comment。这实际上适用于Excel 2007和Excel 2003。
(Add Comments)使用审阅工具栏(Reviewing Toolbar)添加评论
最后,您可以使用Excel中的“审阅”工具栏(Reviewing toolbar)向单元格添加注释。要打开审阅工具栏(Reviewing toolbar),请转到查看(View)、工具栏(Toolbars),然后选择审阅(Reviewing)。
最左边的第一个图标是New Comment 按钮(New Comment button)。单击(Click)它,当前选定的单元格中将出现一个新的注释框。(comment box)
调整评论大小
现在让我们谈谈添加评论后您可以对评论执行的一些操作。首先,让我们简单地调整评论的大小。为此,请单击并拖动注释框(comment box)角或边上的一个手柄。
格式化评论
默认情况下,评论没有格式,但是如果您想更改字体或增加文本大小怎么办?要格式化评论,首先单击单元格,然后单击编辑评论(Edit Comment)。然后右键单击评论内的任意位置并选择Format Comment。
您现在可以更改字体系列、字体样式、字体大小、字体颜色和字体效果。你现在可以自由地让你的评论看起来像你喜欢的那样丑或漂亮。
更改评论形状
默认情况下,评论框(comment box)是一个矩形,但您实际上可以更改评论的形状。如果他们将该选项添加到“评论”选项卡上的“评论”部分会很好,(Review)但(Comments)由于某种原因它不存在。相反,您必须将形状按钮(shape button)添加到快速访问工具栏(access toolbar)。
为此,请单击“文件(File)”选项卡,然后单击“选项(Options)” 。
现在您需要先单击左侧的(hand side)快速访问工具栏(Quick Access Toolbar)。在顶部,您会看到从下拉列表中选择命令;(Choose commands from)继续并从列表中选择所有命令。(All Commands from)向下滚动(Scroll)直到看到Edit Shape,单击它,然后单击Add>>按钮。
要更改注释的形状,请单击单元格并首先单击(cell and click) 编辑注释(Edit Comment)。然后单击快速访问工具栏中的新(access toolbar)编辑形状按钮(Edit Shape button),您将看到一系列可供选择的形状。
将注释复制到不同的单元格
如果您想将评论从一个单元格复制到另一个单元格,它也相当简单。只需(Just)选择单元格,然后按CTRL + C即可复制内容。接下来(Next),转到另一个单元格,右键单击并选择Paste Special。
从列表中选择评论,只有评论会插入到新单元格中。当前驻留在单元中的任何其他内容都将保持不变。
将Windows 用户(Windows User)更改为您自己的名称(Own Name)
您可能已经在上面的屏幕截图中注意到,一些评论以“Windows 用户”开头,这是因为Office的副本默认注册为该名称。您可以通过转到File,单击Options,然后单击General来更改此设置。
如果您不希望评论中出现任何内容或将其更改为您喜欢的任何文本,您可以将其留空。默认情况下,这将出现在所有评论的顶部。
从单元格中删除评论指示符
最后,如果您想从单元格块的顶部隐藏那些小红色三角形,即使评论确实存在,该怎么办?嗯(Well),这也很容易。转到文件(File)、选项(Options),然后转到高级(Advanced)。
向下滚动到显示(Display),然后您会看到一个名为For cells with comments, show:的部分,在这里您可以从三个选项中进行选择:无评论或指示符(No comment or indicators)、仅指示符和悬停(Indicators only, and comments on hover)评论或评论和指示符(Comments and indicators)。
这就是您可以在Excel中使用评论所做的所有事情,因此希望这会让您看起来像办公室中的Excel专家。如果您有任何问题,请发表评论。享受
How to Add Comments to an Excel Worksheet Cell
I’m a big user of Excel and it alwayѕ amazes me how few pеople add comments to their Excel spreadsheets! 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! It’s really easy to add comments to cells in Excel and I’ll explain how you can do so in Excel XP/2003, Excel 2007, Excel 2010 and Excel 2013.
Comments are basically notes that can be inserted into any cell in Excel. It’s useful for reminders, notes for others, and for cross-referencing other workbooks. Note that newer versions of office have a option called Show Ink in the Comments toolbar and this is only useful for tablet PCs. The feature basically lets you handwrite a comment instead of typing one. On desktops and laptops, though, it’s only useful for viewing hand-written comments created on a tablet PC.
Also, there are a lot of other things you can do with comments once you add them to a worksheet like formatting, changing the shape, resizing and so on. Scroll to the bottom of the post for those tips.
Add Comments to an Excel 2013 Cell
Excel 2013 looks a bit different than 2010, but overall it’s pretty much the same. To add a comment, click on the Review tab and click on New Comment once you have selected the desired cell.
Now just type in your comment and when you navigate away from that cell, you’ll see a small red triangle in the upper right corner of the cell indicating that the cell has a comment.
Add Comments to an Excel 2010 Cell
In Excel 2010, adding a comment is super easy and the same as 2013. Just click on the Review tab and you’ll see all the commenting tools. Click on the cell you want to add the comment to and then click on New Comment.
A small dialog window will appear where you can begin typing in text. You’ll also notice the small little red triangle at the top right of the cell, which is there to indicate that cell has a comment.
You can quickly see all comments on a worksheet by clicking on the Show All Comments button. This comes in handy if the sheet has a bunch of comments. You can also click Previous and Next to cycle through all the comments one by one.
Add Comments to an Excel 2007 Cell
The procedure for Excel 2007 is the same as above. The first thing you’ll want to do is click on the cell where you want to insert the comment. Click on the Review tab in the ribbon bar to view the comment editing tools.
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.
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.
Add Comments to an Excel XP/2003 Cell
In Excel 2003 and XP, you have a couple of more options for inserting comments into a cell since there is no ribbon bar. 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. 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. This actually works in both Excel 2007 and Excel 2003.
Add Comments Using Reviewing Toolbar
Finally, you can use the Reviewing toolbar in Excel to add comments to cells. 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.
Resize a Comment
Now let’s talk about a couple of things you can do with the comments once they have been added. Firstly, let’s just simply resize the comment. To do that, click and drag one of the handles on the corners or sides of the comment box.
Format a Comment
By default, there is no formatting on a comment, but what if you want to change the font or increase the size of the text? To format a comment, you first click on the cell and then click Edit Comment. Then you right-click anywhere inside the comment and choose Format Comment.
You’ll now be able to change the font family, font style, font size, font color and font effects. You are now free to make your comments look as ugly or beautiful as you like.
Change Shape of Comment
By default, the comment box is a rectangle, but you can actually change the shape of the comment. It would have been nice if they had added that option to the Comments section on the Review tab, but for some reason it’s not there. Instead you have to add the shape button to the quick access toolbar.
To do this, click on the File tab and then click on Options.
Now you need to click on Quick Access Toolbar on the left hand side first. At the top, you’ll see a Choose commands from drop down; go ahead and select All Commands from the list. Scroll down until you see Edit Shape, click on it and then click on the Add>> button.
To change the shape of the comment, click on the cell and click Edit Comment first. Then click on the new Edit Shape button in the quick access toolbar and you’ll be presented with a whole slew of shapes you can choose from.
Copy Comments to Different Cells
If you want to copy a comment from one cell to another, it’s also fairly-straight-forward. Just select the cell and then press CTRL + C to copy the contents. Next, go to the other cell, right-click and choose Paste Special.
Select Comments from the list and only the comments will be inserted into the new cell. Anything else currently residing in the cell will remain the same.
Change Windows User to Your Own Name
You may have noticed in the screenshots above that some of the comments start out with “Windows User” and that’s because the copy of Office is registered to that name by default. You can change this by going to File, clicking on Options and then clicking on General.
You can leave it blank if you want nothing to appear in the comment or change it to whatever text you like. This will appear at the top of all comments by default.
Remove Comment Indicator From Cells
Lastly, what if you want to hide those little red triangles from the top of the cells blocks even if a comment does exist? Well, that’s easy also. Go to File, Options and then Advanced.
Scroll down to Display and then you’ll see a section called For cells with comments, show: and here you can choose from three options: No comment or indicators, Indicators only, and comments on hover or Comments and indicators.
That’s about all there is you can do with comments in Excel so hopefully this will make you look like an Excel pro at your office. If you have any qestions, post a comment. Enjoy