Comments are a great way to add extra notes and reminders to your workbook. They can also be used for cross-referencing other workbooks. However, newer versions of Office have a feature called Show Ink which is only useful for tablet PCs. On desktops and laptops, though, it’s only useful for viewing hand-written comments created on a tablet PC.
Commenting on a worksheet can be a great way to add extra information, change the shape of the sheet, and resize it. Scroll to the bottom of this post for more tips.
Add Comments to an Excel 2013 Cell
In Excel 2013, the main change is that the Ribbon has been replaced by a more user-friendly interface. To add a comment, click on the Review tab and click on New Comment once you have selected the desired cell.
If you navigate away from the 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.
When you finish typing in your comment, hit the Enter key on your keyboard. The comment will appear in the dialog window and the cell will be highlighted. ..
If you want to quickly see all the comments on a worksheet, you can click on the Show All Comments button. This will show all the comments on the sheet in one place. You can also click Previous and Next to cycle through all the comments one by one.
Add Comments to an Excel 2007 Cell
To insert a comment in Excel 2007, 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.
I was really excited to try this restaurant, but the food was terrible.
Add Comments to an Excel XP/2003 Cell
In Excel 2003 and XP, you can insert comments into cells by using the menus at the top of the screen or by using the reviewing toolbar.
Add Comments Using Menu Bar
Now, you need to enter your comment. Start by typing your comment into the text field at the top of the cell. Then, click on the blue arrow next to the text field and select Insert Comment. Now, you will be able to see your comment in a new cell at the bottom of the page.
In addition to the text box that was present in 2007, a red triangle will now appear at the upper right hand corner of the cell. This indicates that your comment will be publicly visible. ..
Add Comments Using Mouse Context Menu
To insert a comment into an Excel cell, simply right-click on the cell and choose Insert Comment. This works in both Excel 2007 and Excel 2003.
Add Comments Using Reviewing Toolbar
If you want to add comments to a cell, go to the Reviewing toolbar and click the Comment button. Then, type your comment in the text box and press Enter. ..
The New Comment button is a button that appears on the far left of the cell, next to the text box for editing comments. Clicking on it will open a new comment box, where you can add your own thoughts and feedback.
Resize a Comment
Secondly, if you want to remove a comment, just click and drag the handle away from the comment box.
Format a Comment
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 can now change the font family, font style, font size, font color and font effects in your comments. You are now free to make them look as ugly or beautiful as you like. ..
Change Shape of Comment
The default shape of the comment box on a review page is a rectangle, but you can actually change it to a different shape by adding the shape button to the quick access toolbar. This will make it more difficult for people to accidentally type in something that looks like a rectangle.
In the Options dialog box, click on the General tab. Under the General tab, click on the Security tab. Under the Security tab, click on the Authentication and Authorization section. In this section, you can choose to require authentication before files can be downloaded or accessed. You can also choose to require authentication for all files in a folder or for specific files in a folder. If you require authentication for all files in a folder, then every file in that folder must be authenticated before it can be downloaded or accessed. If you require authentication for specific files in a folder, then only those specific files must be authenticated before they can be downloaded or accessed.
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 a comment, click on the cell and click Edit Comment first. Then click on the new Edit Shape button in the quick access toolbar. You’ll be presented with a whole slew of shapes you can choose from. ..
Copy Comments to Different Cells
To copy a comment from one cell to another, you can use the “CTRL + C” keyboard shortcut. Next, go to the other cell and select “Paste Special.” ..
- I think the new cell is too small.
- The new cell is too small and it’s hard to see what’s written in it.
- The new cell is too small and it’s hard to see what’s written in it because the light is bad.
- The new cell is too small and it’s hard to see what’s written in it because the letters are tiny.
- The new cell is too small and it’s hard to see what’s written in it because the letters are so close together that you can’t read them easily. ..
Change Windows User to Your Own Name
If you’re a Windows user, you can change the name of Office to something else by going to File, clicking on Options and then clicking on General.
This will appear at the top of all comments by default.
Remove Comment Indicator From Cells
If you want to hide the red triangles from the top of the cells blocks even if a comment exists, you can do this by going to File, Options and then Advanced.
For cells with comments, show: No comment or indicators: This option displays the cell without any indicators or comments. Indicators only: This option displays the cell with only the indicators. Comments on hover or Comments and indicators: This option displays the cell with both comments and indicators on hover. ..
That’s 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 questions, post a comment. Enjoy
