Where to find insert comment in excel 2010

Do you want to learn more about Excel? If you are using the comments feature within Excel, the first thing you should do is specify options as to how you want comments to display. By default, when you insert comments in cells, Excel will display indicators as red markers in cells with comments. You can also right-click on a cell and choose Insert Comment from the drop-down menu that appears. Once you have inserted a comment, you can enter text in the comment box and drag the borders of the comment to move it or the handles to resize it.

Assuming that you have set the display of comments to show red markers and comments on hover, you may want to show all comments when you are working on them and then later hide the comments to display the red markers again. Assuming that you have set the display of comments to show red markers and comments on hover, you can hide the comments and display the red markers.

You can also right-click on a cell with a comment and choose Edit Comment from the drop-down menu that appears. You can delete all comments in a workbook, hidden or not, using the Inspector. The Inspector is a very important tool and can be used to prevent sensitive information from being sent to a client or third party.

Did you find this article helpful? If you would like to receive new articles, join our email list. To request this page in an alternate format, contact us. How to Convert Text to Numbers in Excel. Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite Toronto Star Building , Toronto, Ontario, Canada some in-person classroom courses may also be delivered at an alternate downtown Toronto location.

Contact us at info avantixlearning. You can convert pounds to kilograms lb to kg or kilograms to pounds using formulas with operators or functions in Excel.

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets — using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners. Avantix Learning courses are offered online in virtual classroom format or as in-person classroom training. Our hands-on, instructor-led courses are available both as public scheduled courses or on demand as a custom training solution.

All Avantix Learning courses include a comprehensive course manual including tips, tricks and shortcuts as well as sample and exercise files. An Options dialog box appears. Click the Advanced category in the left panel.

In the right panel, scroll down to the Display section. In the area For cells with comments, show, choose the desired option. Check No comments or indicators if you do not want the red markers to display. One click and all the comments in the current sheet are displayed on the screen.

After reviewing the cell notes, you can hide them by clicking Show All Comments again. If you have a lot of comments in the spreadsheet, showing all of them at a time can complicate your perception of the data. The rectangular shape, pale yellow background, Tahoma 8 font A standard comment in Excel looks rather boring and unattractive, doesn't it? Fortunately, with a little bit of imagination and skill, you can make it more eye-catching.

There are two more ways to select the comment. Highlight the text where you want to change the font. Right-click on the selection and choose the Format Comment option. The Format Comment dialog window will appear on your screen. Here you can pick the font, font style or size that you like, add different effects to the comment text or change its color.

Make changes that you want and click OK. If you are sick and tired of changing the font size of each single comment, you can apply it to all cell notes at once by changing the settings in your Control Panel. If you want to use a different comment shape instead of the standard rectangle, first you need to add a special command to the Quick Access Toolbar QAT. You will see the Excel Options dialog window on your screen.

Choose Change Shape in the list of commands. Click Add and then OK. To enable the icon, click on the comment border using the four-headed arrow. When the option becomes available, open the Change Shape drop-down list and choose the shape you want. After you've changed the comment shape it can happen that the text doesn't fit the comment box. Do the following to solve this problem:. Now when your comment has its individual style, hardly it will be ignored. If you want the same comment in multiple cells of your worksheet, you can copy and paste it in other cells without changing their content.

This is especially useful when you want to look through a series of comments left by collaborators. After some comments have been added to your spreadsheet, you may want to edit or delete them.

Doing so is easy. Just right-click on the cell with the comment and select Edit Comment or Delete Comment. If you choose to edit, your cursor will move to the text box and you can enter any text you like. You can also use the corresponding buttons in the Review tab, but right-clicking is usually much faster. You need to click the comment box above the cell when you select it:. Even the Review tab works similarly. Forgetting where you got a number, why you put something where you did, or what you were going to do next can put a big damper on your productivity.