如何增加评论到擅长活页练习题细胞
张贴在2008年4月6日在5:34上午
保证读其他岗位从擅长技巧系列!
我是一名大用户擅长,并且它总使我惊奇怎么很少人 增加评论到他们擅长报表! 增加和使用评论擅长是一个巨大方式解释惯例、细胞和其他数据在报表,因而挽救您在电话上花费的时间与同事! 增加评论到细胞擅长是真正地容易的,并且我将解释怎么您能做,因此擅长XP/2003并且擅长2007年。
评论基本上是可以被插入入所有细胞擅长的笔记。 它为提示,笔记是有用的为其他和为相互参照其他作业簿。
如何增加评论到细胞擅长2007年
您将想要做的第一件事是点击细胞,您想要插入评论。 在擅长2007年,您能增加评论到活页练习题通过去 回顾 制表符在丝带酒吧。
在 评论 小组,点击 新的评论. 在擅长报表评论正文框将出现您能输入您新的评论的地方。
当您做时,输入您的评论并且点击在正文框外面。 您注意有一个小红色箭头在上面权利细胞,表明这个细胞有一个评论。 点击在细胞自动地提出评论。
如何增加评论到活页练习题擅长XP/2003
在擅长2003年,并且XP,您有两三个更多选择为插入评论入细胞,因为没有丝带酒吧。 您能使用菜单在上面、老鼠上下文菜单或者回顾的工具栏。
使用目录杆增加评论
首先,您需要点击到里您想要插入评论的细胞。 然后点击 插入物 菜单选择和选择 评论.
在2007年内象,正文框在细胞旁边将出现,您能进入您的评论。 并且,一个红色三角出现于细胞的右上角。
使用老鼠上下文菜单增加评论
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.
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: add comments to 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!
» Filed Under MS Office Tips
Save this page |
Stir it up on Mixx |
|
Add to Reddit |
Related Posts
- How to use Data Validation in Microsoft Excel to create dropdown lists
- Microsoft Excel Basics Tutorial - Learning how to use Excel
- How to add music to PowerPoint
- How to add buttons to the Quick Launch toolbar in Windows
- How to securely password protect an Excel file
Save this page
Stir it up on Mixx
Add to Reddit
























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. 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’s a 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!