In earlier versions of Excel you could insert a comment on the worksheet, and then use the Drawing toolbar commands to change the comment's rectangle to a different shape.
在早期版本的Excel中,您可以在工作表上插入注释 ,然后使用“绘图”工具栏命令将注释的矩形更改为其他形状。
It's not a technique that you'd want to use too often, but it can add impact to a worksheet if used sparingly.
这不是您不想经常使用的技术,但是如果使用不多,可能会增加对工作表的影响。
![CommentStar CommentStar](https://i-blog.csdnimg.cn/blog_migrate/f60df05c289d18737dde96abf9159600.gif)
In Excel 2007, the Drawing Tools Format tab doesn't appear on the Ribbon when you select a comment, so the Change Shape command isn't available.
在Excel 2007中,当您选择注释时,“绘图工具格式”选项卡不会显示在功能区上,因此“更改形状”命令不可用。
It's still possible to change the comment's shape, but it takes a bit more effort.
仍然可以更改评论的形状,但是需要花费更多的精力。
添加更改形状命令 (Add the Change Shape Command)
The first step is to add the Change Shape command to the Quick Access Toolbar (QAT):
第一步是将“更改形状”命令添加到“ 快速访问工具栏” (QAT):
- Right-click the QAT, and click Customize Quick Access Toolbar 右键单击“ QAT”,然后单击“自定义快速访问工具栏”
- In the Choose commands from drop down list, click Drawing Tools | Format Tab 在“从中选择命令”下拉列表中,单击“绘图工具” |“工具”。 格式标签
- In the list of commands, click Change Shape, and click Add 在命令列表中,单击“更改形状”,然后单击“添加”。
![ChangeShapeAdd ChangeShapeAdd](https://i-blog.csdnimg.cn/blog_migrate/891c2f8e75e65af68e9a3675933480ec.gif)
- Click OK to close the Excel Options window. 单击“确定”关闭“ Excel选项”窗口。
更改评论形状 (Change the Comment Shape)
- Select the cell that contains the comment 选择包含评论的单元格
- On the Ribbon, click the Review tab, and click Edit Comment 在功能区上,单击“审阅”选项卡,然后单击“编辑评论”。
- Click the border of the comment, to select the shape. 单击注释的边框,以选择形状。
- On the QAT. click Change Shape, and click on the shape that you want to use. 在QAT上。 单击更改形状,然后单击要使用的形状。
![CommentChangeShape CommentChangeShape](https://i-blog.csdnimg.cn/blog_migrate/8a4bd9e2d29bc896270e8919ed11ae55.gif)
观看视频 (Watch the Video)
To see the steps for adding the Change Shape command, and changing the comment shape, you can watch this short Excel video tutorial.
要查看添加“更改形状”命令和更改注释形状的步骤,您可以观看此简短的Excel视频教程。
翻译自: https://contexturesblog.com/archives/2009/04/19/change-a-comment-shape-in-excel-2007/